Apr 14 2011, 09:45 PM
I'm trying to use a For-Next loop to automate the process of linking to many .xlsx files. This is Access 2010.
Here's the link Acces chokes on:
DoCmd.TransferSpreadsheet acLink, acSpreadsheetTypeExcel12, strTName, strFileName, True
I have tried these other options as well:
DoCmd.TransferSpreadsheet acLink, acSpreadsheetTypeExcel9, strTName, strFileName, True
DoCmd.TransferSpreadsheet acLink, 10, strTName, strFileName, True
I get runtime error 3845:
"Microsoft Access does not support linking to an Access database or Microsoft Office Excel workbook saved in a format that is a later version than the current database format."
Is this just sloppy programming on MS' part, with a bad error description, or is there a version of Excel that is later than Office 2010?
Apr 14 2011, 10:56 PM
Update - I get the same error message when I try to manually link to these spreadsheets.
The link manager opens the spreadsheets, and properly divides the columns into fields, and recognizes the first row as field titles, and allocated data types for the field, and then, in the last step, after clicking on the Finish button, it says
"Microsoft Access does not support linking to an Access database or Microsoft Office Excel worksbook saved in a format that is a later version than the current database format."
Apr 15 2011, 12:26 AM
Just to be clear. You are linking FROM an accdb format database (i.e., one based on the 2007 file format) TO an Excel spreadsheet. Correct?
Apr 20 2011, 06:55 PM
thanks - that was it. I was still in the old .mdb format.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here