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
Microsoft AccessMicrosoft Applications
Last Comment
Eric Sherman
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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