Monthly Spreadsheet Import to Multiple Tables

[daveWP]

I have a monthly spreadsheet summary that I want to import to my database. This spreadsheet is the result of compiling all the key relationships together.

Does anyone know the best way to chop up the spreadsheet based on fields and have the target columns and records disbursed to the appropriate parent tables? Like re-engineering the database on which this spreadsheet was compiled.

Also, how can I generate primary keys in the tables when there are new keys that didn't exist in the prior month.

my schema has these kinds of relationships throughout:

tbl_master.uniqueID(PK1)
tbl_history.uniqueID & month (FK1)

 

[ajetrumpet]

don't know if this will help, but may give you some ideas.... http://www.access-programmers.co.uk/forums/showthread.php?t=158308

 

[daveWP]

thanks Aje