Solved

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

Posted on 2014-03-24
8
375 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 29

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 29

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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 

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
 
LVL 29

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 29

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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I wanted to share this with fellow Experts, who might not know. How often have you wanted to learn something, only to be set back by either restrictions imposed on "trial" or "evaluation" software?  How often have you had to rebuild a home networ…
MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

785 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