Importing unopened Excel files

[deejay_totoro]

Hello,

I'm trying to import a series of Excel .xls files in to an Access database,

Using the following, the spreadsheets will only import if they are already opened in Excel.

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97, "myTable", myPath & "\spreadsheet.xls", True, "A1:Z20000"

Is it possible to import spreadsheets without having to keep them open in
Excel?

Many thanks,

Dj_T

 

[stopher]

Hi Deejay
You should not need to open the file in excel. Are you sure that the file and path name are correct ? Have you set any security on the excel file ? What error message are you getting when you try to import ?
Stopher