durick
asked on
DoCmd.TransferSpreadsheet acImport works with .xls but fails with .xslx files
code.txt
.xls files import fine
but .xslx files are all garbage characters
SAMPLESPEC.xls
SAMPLESPEC.xlsx
Clipboard01.jpg
Clipboard02.jpg
.xls files import fine
but .xslx files are all garbage characters
SAMPLESPEC.xls
SAMPLESPEC.xlsx
Clipboard01.jpg
Clipboard02.jpg
here are different AcSpreadSheetType types
https://msdn.microsoft.com/en-us/library/office/ff196017.aspx
https://msdn.microsoft.com/en-us/library/office/ff196017.aspx
ASKER
I'm runing Access 2003, with Excel 2013
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
XLS is the default file format for the 2003 version of Excel and older while XLSX for versions since 2007
Save the .XLSX file as .XLS if you are using Access 2003.
ET
Save the .XLSX file as .XLS if you are using Access 2003.
ET
For XLSX files you would probably need Access 2007 and later versions.
ET