File importing: directing rows in Excel sheet based on condition

[TheRealMcGee]

I'm wondering if this is possible and, if so, a web resource that can show me how to do it. Essentially I have multiple Excel spreadsheets maintained and updated by outside parties that need to be periodically imported into my database. Problem is I can't just use the simple import function in Access as the data in the spreadsheets need to go in one of three tables based on the data in the "Type" row of the spreadsheet. A simplified version the spreadsheet looks like this:

ID | Type | Content
1 | Type A | Content for ID 1
2 | Type C | Content for ID 2
3 | Type B | Content for ID 3


4 | Type A | Content for ID 4
5 | Type B | Content for ID 5
6 | Type C | Content for ID 6
7 | Type B | Content for ID 7

My database has three tables: Type A, Type B, Type C. When importing the spreadsheets, the rows in the spreadsheet needs to be siphoned into the appropriate table on the basis of Type. In the above spreadsheet, IDs 1 and 4 need to update the "Type A" table, IDs 3, 5 and 7 the "Type B" table, and IDs 2 and 6 the "Type C" table. Also, most of the time it will an updating of exiting rows in the tables, but sometimes new rows will need to be inserted, thus new IDs generated.

Many thanks.

[ranman256]

Save the XL book to the same place...c:\temp\file2import.xlsx
link it into the db as an external table.
make all your import queries to import the data into the target tables.
put all these queries into a macro.
Put a macro in XL to run the SAVE AS c:\temp\file2import.xlsx

then the steps are:
get the new file, run the xl SaveAs macro,
then run the access imort macro,
done.