Importing Excel 2.1 into Access 2002

  • Thread starter Thread starter Kole
  • Start date Start date
K

Kole

I am trying to import an Excel 2.1 Spreedsheet into
Access 2002 and get an error that the format is not
recognized. I can only get the file in 2.1. The only way
I can get the Excel file to import is to open it and re-
save as Excel 97/2002. I am trying to avoid that
additional step.
 
You can't.
You have to do that step.

The only question is if you can automate it or not.
I think Access can automate Excel and open and save the file in the other
format.
So as part of your import process you could perform that action and then
import the newly saved file.
 
Hi Kole,

I think that's the only thing to do. However, you could make it a
one-step process for the user by using Automation to fire up Excel and
open and convert the workbook before importing the revised version.
 
Back
Top