Solved

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

Posted on 2014-03-24
8
401 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SignTool Error with Windows 10 5 258
SCCM2012 sp2 CU3 cant see boot images missing tabs 3 141
Display multiple images in report 12 121
SCOM monitoring possibilities? 9 57
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…
Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

732 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