Importing Multiple Workbooks from Excel to Access 1

[monrosal]

Does anyone know how I can specify which workbook to import when I use the TransferSpreadsheet? In the code, there is no argument to specify a workbook. Is there another method I can use? Thanks

Ramon

 

[ottenbrj]

Did you find out how to do this? I am attempting to import about 150 Excel workbooks (each with 10 spreasheets) into Access. It is killing me?!

 

[tlbroadbent]

Use the Range parameter to name the spreadsheet.

Example:

DoCmd.TransferSpreadsheet acImport, _
acSpreadsheetTypeExcel9, "TableName", _
"c:\data\excel\workbookname.xls", _
False, "spreadsheetname!"

NOTE: The ! is required. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.