Add Autonumber while importing through a module

  • Thread starter Jeffrey M via AccessMonster.com
  • 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
 
B

Brian

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.
 
Top