Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2014-03-24
8
Medium Priority
?
433 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 1000 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Problem: You created a new custom form in Outlook for your contacts (added fields, deleted fields, changed the layout of fields, whatever) and made it the default form for contacts. The good news is that all new contacts will utilize the new form. T…
The canonical version of this article is on my web site here: http://iconoun.com/articles/collisions/ A companion presentation is available here: http://iconoun.com/articles/collisions/Unicode_Presentation.pdf
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 viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

636 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