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

Macro to import the spreadsheet with indexed field (* AUTO NUMBER)

P: 1
I can import the EXCEL spreadsheet using the macro in ms access but the table is not indexed with the Autonumber as we get in the manual import operation.

Please assist me to get the indexed data with the import values ,as I need to replace the database daily with the new values keeping the index as the key value.
Nov 14 '06 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,489
Try importing the data into one table, then run a query which selects records from that table and appends them to the main table afterwards. If you need to, you can run another query which clears down the main table beforehand to have a clean dataset of only the new items.
Nov 14 '06 #2

Post your reply

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