Solved

Importing a MSACCESS2007 table into SQL2008 "Unrecognized database format.."

Posted on 2014-03-24
8
356 Views
Last Modified: 2014-03-25
In SQL2008, I select "Tasks"/Import Data, For Data Source, I select:  Microsoft ACCESS.
I then select my SCCESS db:  "PM.accdb".  when I click on "Next", I get the following message:
TITLE: SQL Server Import and Export Wizard
------------------------------

The operation could not be completed.

------------------------------
ADDITIONAL INFORMATION:

Unrecognized database format 'P:\Main\IS-PH\Bill\PerfMeasures\PerfMeasureDan_NewData.accdb'. (Microsoft JET Database Engine)

------------------------------
BUTTONS:

OK
------------------------------
0
Comment
Question by:willjx
  • 4
  • 4
8 Comments
 
LVL 28

Expert Comment

by:becraig
ID: 39951667
You might want to install the Access components on the SQL server so it can access they Access DB.

http://www.microsoft.com/en-us/download/details.aspx?id=23734

It might also be helpful to validate that you can setup an odbc when done.
0
 

Author Comment

by:willjx
ID: 39951845
Still get the same message.  I installed and ran the noted download on the server.
-still get the same message.
fyi : back in August I somehow did import all my ACCESS tables to the noted SQL server, and users are now using the ACCESS DB, via all the tables linked to the SQL database.
Now, I found it necessary to redesign one of the tables w/ a table driven pick list, and created the new picklist table.  Now, I am trying to import them back into my SQL DB, and i seem to have forgotten what i did before to avoid the message:  "Unrecognized database format..."
0
 
LVL 28

Accepted Solution

by:
becraig earned 500 total points
ID: 39951859
Can you take a look at the information here :
http://www.fmsinc.com/MicrosoftAccess/SQLServerUpsizing/importing/ErrorsImportingFromACCDB.asp

Also is this a 32 or 64 bit Access DB  ?
0
 

Author Comment

by:willjx
ID: 39951968
32 bit
I used the site recommended:  "MS office 12 access databae engine OLE DB..."which is what i believe I successfully did before.  However, now I get the following message when neither I nor anyone else is using the DB:


"TITLE: SQL Server Import and Export Wizard
------------------------------

The operation could not be completed.

------------------------------
ADDITIONAL INFORMATION:

The Microsoft Office Access database engine cannot open or write to the file 'P:\main\IS-PH\Bill\PerfMeasures'. It is already opened exclusively by another user, or you need permission to view and write its data. (Microsoft Office Access Database Engine)

------------------------------
BUTTONS:

OK
------------------------------
"
0
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 
LVL 28

Expert Comment

by:becraig
ID: 39952042
This sounds as if the db file is in use somewhere either as a link or something else.

I would probably just as a test make a copy of the db and try importing that to ensure it is indeed a file access issue.
0
 

Author Closing Comment

by:willjx
ID: 39954697
Knowing I was using ACCESS 2007 and trying to import to SQL2008 with MS ACCESS,
an "Expert" should have simply told me using "MS ACCESS" does not work.
Required to be used is:  "Microsoft Office 12.0 Access Database Engine OLE DB Provider".
(as you more indirectly adivised me by supplying the last url). Thank you.
Furthermore, to get rid of the erooneous msg that someond was using the system:  the path must not just include where the document is, but also actually name the .aadb file.
All is now well.
Thank you.
0
 
LVL 28

Expert Comment

by:becraig
ID: 39954705
I erroneously usually assume there is a basic understanding of what's being done unless explicitly called out. I apologize if I get you there more slowly than expected.
0
 

Author Comment

by:willjx
ID: 39954711
Apology accepted.
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now