Problems with importing Excel 2010 files in Access 2003

Question

I have an Access 2003 application where I previously without any problems have imported Excel 2010 files (in 2003 format).

With the last Office-update it seems that changes has been made i Excel. The Access import wizard no longer can import the Excel files (cannot find the file/wrong format).

I can import the Excel file if the imported file is open (and therefore in compatibel version), but not if I don't have the actual file open!

This is quite annoying - does anyone have a solution?

Answer 1

Hello,

Thanks for posting on MSDN forum.

The support for Office 2003 has been stopped and we failed to reproduce your issue since we do not have Office 2003. I would suggest you update your Access to Access 2010 or later for a better product experience.

Hope other community members could give you useful suggestion.

As a temporary workaround, you could try to revert your office to previous version to make the application work.

Best Regards,

Terry

---

MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 2

I can import the Excel file if the imported file is open (and therefore in compatibel version), but not if I don't have the actual file open!

This is quite annoying - does anyone have a solution?

Hi mkochp,

Does it help if you convert the Excel 2010 file to csv-format?

Imb.

Answer 3

Did you try linking the Excel file and then running an Append query?

---

Build a little, test a little

Answer 4

Hi mkochp,

first I suggest you to save the Workbook in "Excel 97-2003" Format.

which can be supported by Office 2003.

if that also not get open in Access then open the same file in Excel 2003 and save as it in Excel 2003 Application.

then you can use it to import data in Access.

other way is to use VBA to import data from Excel to Access.

Example:

DoCmd.TransferSpreadsheet acImport, 3, _ 
 "Employees","C:\Lotus\Newemps.wk3", True, "A1:G12"

Reference:

DoCmd.TransferSpreadsheet Method (Access)

Regards

Deepak

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].