By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,471 Members | 2,264 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,471 IT Pros & Developers. It's quick & easy.

Need help with importing excel files

P: 1
Hello Helpful Members,
I'm fairly new to access, and already need some help. I'm trying to establish a business process where a provider sends a daily excel report to me that I upload into access. The trick is that I want the daily upload to replace only fields in the table that have new entries. Is this possible?
Jun 5 '07 #1
Share this Question
Share on Google+
1 Reply


Luigi
P: 4
Hello Helpful Members,
I'm fairly new to access, and already need some help. I'm trying to establish a business process where a provider sends a daily excel report to me that I upload into access. The trick is that I want the daily upload to replace only fields in the table that have new entries. Is this possible?
I thing you must have an internal table with the Current situation and than another table CONNECT to an excel file (make a working copy of the incoming file with a fixed name). So you can make a COMMAND QUERY that finds the different and up-date the Current table.
Jun 5 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.