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

Similar Threads

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
ODBC Microsoft Access Driver Login Failed 0
help to understand 'querytable' 1
Get External Data returns error message 3
Get External Data 10
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
HELP: Not able to generate query from excel for access 2007 1
Insert data in access by excel. 0

Top