• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1672
  • Last Modified:

Importing Access 2010 accdb into SQL

I'm in SQL Server trying to import tables from an accdb file and I get this error:

TITLE: SQL Server Import and Export Wizard
------------------------------
The operation could not be completed.

------------------------------
ADDITIONAL INFORMATION:
Unrecognized database format 'J:\MyDatabase.accdb'. (Microsoft JET Database Engine)

Why does it not recognize my accdb?
0
gcgcit
Asked:
gcgcit
  • 3
1 Solution
 
nsonbatyCommented:
did you use Compact and Repair option in access 2010, because this will give you this error when you inport it to SQL
0
 
peter57rCommented:
Which version of SQL Server?
0
 
nsonbatyCommented:
this link for the same problem with access 2007, but it is applicable for access 2010

http://www.fmsinc.com/MicrosoftAccess/SQLServerUpsizing/importing/ErrorsImportingFromACCDB.asp
0
 
gcgcitAuthor Commented:
Using SQL Server 2005
0

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now