Get External Data From Access

H

Heera

Hi,

I am trying to import data from access database which is there on the share
drive.
I have excel 2007 I went in Data tab then> Get External Data>From Other
Sources>
From Microsoft Query>Then I seleted MS Access Database

Said "OK" mentioned the networkpath and double clicked on the file and said
ok.

But I got the follwoing error message
---------------------------
ODBC Microsoft Access Driver Login Failed
---------------------------
Unrecognized database format 'Z:\Testdata.accdb'.
---------------------------
OK Cancel
---------------------------

Once I click on ok it is asking from Login Name & Password.

I dont know how to fix this error and what it is.......please help me......

Regards
Heera
 

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

Top