Import From Excel To multi tables in Access

  • Thread starter Thread starter Tony M via AccessMonster.com
  • Start date Start date
T

Tony M via AccessMonster.com

I have a data entry Excel template that the off-site client has. The column
names and data is all on one Excel sheet.
I need to import the sheet into a new table in Access. Then once it's there
tell Access somehow, to append fields 1-4 to table-1; fields 4-8 to table-2,
etc.

Is this possible?

I have a button on a form that I want to accomplish this task (the import and
the appends). Does anyone know the code to do the appends?

Thanks
Tony
 
You don't need any code. You just need two append queries. Both will use
the imported table as the source. One will append fields 1-4 to the
corresponding fields table 1 and the other field 4- 8 to the corresponding
fields in table 2.
 
Back
Top