Import Office 2007 (xlsx) Spreadsheet into an Access 2003 MDB
Posted on 2012-09-21
I have client currently using Access 2003 with no plans to upgrade to a newer version of Access.
One of their customers is going to be sending spreadsheets to be imported into the Access 2003 MDB. The customer spreadsheets are generated in a newer version of Excel and come in with an xlsx extension. My client has no say in the format of the sent spreadsheet.
Is their any way to import one of the xlsx spreadsheets directly into Access 2003 without opening it an saving as an xls file?
These users are not particularly technical and the best workflow would if the system could import the file in the format it is sent.