Link to home
Start Free TrialLog in
Avatar of durick
durickFlag for United States of America

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
Avatar of Eric Sherman
Eric Sherman
Flag of United States of America image

Which version of Access are you using???

For XLSX files you would probably need Access 2007 and later versions.

ET
Avatar of crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access

here are different AcSpreadSheetType types

https://msdn.microsoft.com/en-us/library/office/ff196017.aspx
Avatar of durick

ASKER

I'm runing Access 2003, with Excel 2013
ASKER CERTIFIED SOLUTION
Avatar of crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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