Docmd.TransferSpreadsheet question

[polina]

Hi,

The spreadsheet file I want to import has 2 sheets in it.

Using this line, I only get the first sheet imported:
DoCmd.TransferSpreadsheet acImport, , "Eroom", path, True

How to import two sheets of into two different tables?

Thanks.

 

[CBragg]

When i use the transfer spreadsheet command i get an error message saying 'Field F1 does not exit in 'Table Name'.

I think this is something to do with my MS Access but im not so sure. Any ideas??

 

[CBragg]

You could try this code, it will transfer on sheet to one table and your second sheet to another table. Hope this works, let me know how you get on.

DoCmd.TransferSpreadsheet acImport, 8, "tblTest", "path", True, "Sheet1!A1:B14"

DoCmd.TransferSpreadsheet acImport, 8, "tblTesting", "path", True, "Sheet2!A1:B14"