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