Import spreadsheet via VBA module

[DEllis]

Hi Everyone, I have been trying to use VBA to import a spreadsheet using the following code:

Function Import_Vendor_Invoice()

DoCmd.TransferSpreadsheet acImport, 3, "TBL_one", "C:\Users\UserName\Documents\Data\Database Samples 2.xls", True, "Sheet1!A1:K18"

End Function

This does not work. I get an error 3918.

I have Office 365 Access and I have tried Access 2010 as well.

Any help is greatly appreciated.

Thank you,
DEllis

 

[Joe4]

Where did you get the three from?
It looks like that is an option for importing LOTUS spreadsheets.
See:
https://msdn.microsoft.com/en-us/library/office/ff844793.aspx
and
https://msdn.microsoft.com/en-us/library/office/ff196017.aspx

 

[DEllis]

Thanks Joe4, I replaced the 3 with a 9 and works like a charm!

As always this board is awesome!
DEllis