Hi,

I have an Access database program to read the data from the Excel files and
insert the data into one of the table. Both of the Access database and Excel
files were created in 2003 version and they worked well in the 2003 version.
Now I have a 2007 version, and try to do the same process. After I run the
database program, no data were loaded in the database table. I manually click
on the excel file (2003 version), only the 2007 excel background file open
but not the excel workbook file. I converted the 2003 version excel file to
2007 version, and click on it, still the file cannot be opened. I found a way
to open the file manually by opening the 2007 excel program first, then
select and open the file. But when the database program opens the Excel file
to read the data, how can the database manually to do it? If the excel file
cannot open, how can the program read the data from the excel file? How can
I do? Please help me. Thanks!