Add Autonumber while importing through a module

  • Thread starter Thread starter Jeffrey M via AccessMonster.com
  • Start date Start date
J

Jeffrey M via AccessMonster.com

I'm importing an Excel Spreadsheet through code and would like to add an
autonumber ID field during the import process (not by touching the
spreadsheet first). Thoughts?

Thanks,
jeff
 
One idea: run your code to import the spreadsheet into a new table. Then run
code to create an AutoNumber field in the new table. Search this forum for
"create field programmatically" for details.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transfer Spreadsheet w/ autonumber 3
Importing text 4
Microsoft Works to Microsoft Office 6
autonumber reset again 8
Importing data from excel spreadsheet 1
Import Excel check field names Please Help 1
Autonumber Drastic Increase 4
Module that caculates the difference between times 1

Back
Top