Access 2013 adamantly refused to have anything to do with the Access 97 file, but SQL Server imported the tables without complaint.Īt that point you could import the tables from SQL Server into an Access 2013 database. I just tried that with a 32-bit version of SQL Server 2008 R2 Express Edition and it worked for me. have the SQL Server import utility use Jet * ODBC to import the tables into SQL Server.install a 32-bit version of SQL Server Express Edition, and then.In that case, a possible workaround would be to Unfortunately, from now on many people will have difficulty getting their hands on a legitimate copy of Access 2003 (or any other version prior to Access 2013, or whatever the latest version happens to be). As noted in another answer, the official word from Microsoft is to open an Access 97 file in Access 2003 and upgrade it to a newer file format.
