Hi Richard,

I get that, having to remove the asterisk and only inserting the fields that I want. But the problem is that, for example the records which is being copied from table 1 into table 2 will not display the ID's from table3. How does the apply in my case scenario.

An example done in the QBE is as follows, with SQL code:
INSERT INTO Table2 ( ID, VendorID, VendorName, Inventory, InventoryValue, DateAdded )
SELECT DLookUp("ID","Table3","VendorID=" & [VendorID]) AS ID, Table1.VendorID, Table1.VendorName, Table1.Inventory, Table1.InventoryValue, Table1.DateAdded
FROM Table1;

above SQL gives me the below result, which I have been tryig to do in VBA

TABLE 2 (what it should look like)...
ID VendorID VendorName Inventory InventoryValue DateAdded
1 1427036 Procter and Gamble 350 $400,000.00 7/08/2012
2 1428757 Reckitts
3 1429444 Natures Organics
4 1412269 Colgate Palmolive 400 $500,000.00 6/08/2011
---------------------------------------
Table 3 only holds the below:

ID VendorID VendorName
1 1427036 Procter and Gamble
2 1428757 Reckitt Benckiser
3 1429444 Nature Organics
4 1412269 Colgate Palmolive
---------------------------------------
Table 1 is the import table

VendorID VendorName Inventory InventoryValue DateAdded
1412269 Colgate Palmolive 400 $500,000.00 6/08/2011
1427036 Procter and Gamble 350 $400,000.00 7/08/2012
1428757 Reckitts
1429444 Natures Organics
Hope that this all make sense.

---

Reply from Richard Rost:

I'm lost. Tell me what you HAVE and what you're trying to GET and maybe I can help you better if I can approach the problem from the beginning instead of trying to fix what you've already done.