import spreadsheet

[slimjen]

all, i want to transfer 2 spreadsheets from two different workbooks into 1 table in access 2003. i've search the transferspreadsheet code but the arguments are confusing.

 
DoCmd.TransferSpreadsheet acImport, 3, _
    "Employees", "C:\Lotus\Newemps.wk3", True

what does the 3 stand for? do I use two docmd lines to import 2 sheets into 1 table?


thanks

[apr pillai]

If it is a one time operation then I think it is better if you try to link both XL Tables (or import them) into Access. Create Append Queries to transfer the data into the target table.

You can even create a Query (without linking the xl tables into Access) refering the xl tables directly in the Query and add the data into the target table. You can learn this method from here.