Import From Excel To multi tables in Access

[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

 

[Guest]

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.