Solved

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

Posted on 2014-03-24
8
414 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 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

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…
Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

719 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