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

reach2prakash

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.

NeoPa

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.

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

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

/bytes/development

/bytes/it

/bytes/about