Hi,
I have looked around but still I am unable to find an answer.
How do I use doCmd.TransferSpreadsheet to import an excel sheet to access.
Here is what doesn't work:
How do it do it??
I have looked around but still I am unable to find an answer.
How do I use doCmd.TransferSpreadsheet to import an excel sheet to access.
Here is what doesn't work:
Code:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "DrawingSheet", fileName, True, "DrawingSheet"
'fileName is a variable with the full path and filename of the excel workbook
If I make "DrawingSheet" the first sheet and remove it from the statment it works, But I have to import 7 sheets to the database into different tables.Run-time error '3011'; The MS Jet dB engine could not find the object 'DrawingSheet'. Make sure the object exists and that you spell its name and path name correctly.
How do it do it??