Excel Data Export to MS Access Import distributing to different Access tables

[ccotten]

Hi, please let me know how I may export data from an Excel spreadsheet mapping the columns to import into several different separate MSAccess table fields.

Thank you in advance for any insight you may share. I greatly appreciate it.

--Racking my brain

[aytee111]

Do you mean import from Excel? Once the data is imported the data will reside on a table. Use a number of queries to append the data to the respective tables.

[ccotten]

Yes, I'm referring to importing from Excel's many columns, where each spreadsheet column represents a different table, into the different respective MSAccess tables. Thank you.

[aytee111]

Create a query for each table and append the respective column.

[ranman256]

save (or copy) the new file to the same file everytime, File2Import.xlsx
LINK this file in as an external table
then build all the queries needed to update the tables needed.
put all queries into a macro,
then:

1. overwrite the File2Import.xlsx
2. run macro
done.

[ccotten]

Thank you BOTH! I'll certainly try your suggestions asking any questions if I have any.