Import Excel data into Multiple related tables

[duvenhlc]

I have a database that work fine. I need to transfer data from excel into it. I can do it and see the data in the table. The problem is how do I transver this information to three or four different tables which are linked with a "one to many" relationship. I also do not want it to create duplicates on the "one" side of relationship. There are some of the fields that are duplicted in both tables, the one record needs to ne transvered into tow tables. I use the duplication for references elswhere and cannot delete them.

Thanks

 

[llkhoutx]

Use the docmd.transferspreadsheet instruction to import the spreadsheet into a temporary table, then manipulate, copy it from there.

 

[duvenhlc]

How do you do that? I got all th info I need in a table by means of the transferspreadsheet method. How do I take that one table to three tables with a realationship, without duplicatng the records on the "higer" level of the relationship. The results will be taken up in an treeview, so the records in the first table may not be duplicated.

 

[llkhoutx]

Use append or make table queries to build the 3 tables, or cycle through the records of the original table with DAO or ADO VBA code.

 

[duvenhlc]

Can you give me an example, my access knowledge is not that advanced. I did manage to get some amazing fings right. I dit put up a sample DB in the system, that will show what I need.

Help will be creatly appreciated.

 

[roi8877]

Did you ever get this accomplished? I'm trying to do the same thing, only complication on my end is the table im importing too already has existing records..