Cannot import Excel spreadsheets into Access 2003

J

Jay Marshall

A user of mine is running Access 2003 on a new Windows XP computer. He's
going through his usual import procedure (File >> Get External Data >>
Import). He drills down and selects spreadsheet he wants to import from,
clicks 'Import' and gets a message saying:

'The Microsoft Jet database engine could not find the object
"Spreadsheet$". Make sure the object exists and that you spell its name and
the path name correctly.'

Using my own machine with Access 2003, I'm able to import the data to this
database from these spreadsheets with no problem. My machine is running
11.6355.6408 (SP1) while is is the more updated 11.6566.6568 (SP2).

This leads me to believe there's a problem with his Access (or Excel)
settings. In the Visual Basic Editor he has checked VB For Applications, MS
Access 11.0 Object Library, OLE Authentication, MS ActiveX Data Objects 2.1
Library, MS Excel 11.0 Object Library, and the MS DAO 3.6 Object Library.

Has anyone seen this behavior? Any advice is much appreciated....

Jay
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Integrating information from Word to Excel (not mail merge) 1
ISO best steps to export (import) all from Outlook 2003 to Outlook in MS 365 0
Linking data in MS Word into Excel 5
Acc2000 with Acc2003 Obj Lib Reference Issue 1
2007 not playing with 2003 2
Microsoft DAO 3.6 Object Library 5
Problems starting Word from Excel VBA 3
Access 2003 and excel 0

Top