Solved

SQL Server - Cannot import Access table

Posted on 2014-04-07
14
437 Views
Last Modified: 2014-04-07
Got this error (see attach) when importing an Access table 2010 to the SQL Server 2005 using the Import/Export Wizard. Please help.
0
Comment
Question by:HNA071252
[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
  • 8
  • 6
14 Comments
 
LVL 22

Expert Comment

by:plusone3055
ID: 39984015
greetings
you need to try attaching the error again its not part of your post
0
 
LVL 22

Expert Comment

by:plusone3055
ID: 39984018
the easiest fix would be this ...

Open your table in Access2010, and then use Import/Export to convert table from Access to SQL 2005

as long as the access database isnt corrupted it convert fine and then you can import into Sql Server :)
0
 

Author Comment

by:HNA071252
ID: 39984062
This is a very large table, I find it's a lot quicker to import from the SQL Server than export from Access. I didn't have any problem import the same table that is in Access 2003, but now I have this table converted in Access 2010 and I'm getting this error.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 22

Expert Comment

by:plusone3055
ID: 39984074
i unserstand.
 The reason you had no issues before is you had in 2003. Its versioning :(

my apologies
the most painless way to do this is the suggestion above which is opening it in 2010 and using import /export to convert it back to 05 :(
0
 

Author Comment

by:HNA071252
ID: 39984121
This option isn't possible either because I no longer have Access 2003, it's taken away. I only have Access 2010 and I need to be able to import it from the SQL Server 2005.

I've attached the error in the doc.
SQL-Server-Cannot-import-Access2.docx
0
 
LVL 22

Expert Comment

by:plusone3055
ID: 39984134
0
 

Author Comment

by:HNA071252
ID: 39984221
I'm sorry I didn't understand what's in the link. Can you please be more specific? I'm still learning.
0
 
LVL 22

Accepted Solution

by:
plusone3055 earned 500 total points
ID: 39984254
here is an explanation  to the software :)
http://www.microsoft.com/en-us/download/details.aspx?id=28763

this is a free tool :)


SQL Server Migration Assistant (SSMA) is a free supported tool from Microsoft that simplifies database migration process from Access to SQL Server. SSMA for Access automates conversion of Microsoft Access database objects to SQL Server database objects, loads the objects into SQL Server, and then migrates data from Microsoft Access to SQL Server.
 SSMA for Access v5.2 is designed to support migration from Microsoft Access 97 and higher to all editions of SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, and SQL Azure.
0
 

Author Comment

by:HNA071252
ID: 39984278
So if I install this then I'll be able to import Access 2010 tables to the Sql Server 2005?
0
 
LVL 22

Expert Comment

by:plusone3055
ID: 39984281
yes you can with this tool :)
0
 

Author Comment

by:HNA071252
ID: 39984312
I've installed the software, and refresh the license. What do I do next? How do I use it?
0
 
LVL 22

Assisted Solution

by:plusone3055
plusone3055 earned 500 total points
ID: 39984320
here is a "manual" of sorts from our good friends at Microsoft :)

http://technet.microsoft.com/en-us/library/hh313051.aspx
0
 

Author Closing Comment

by:HNA071252
ID: 39984382
This is great. Thank you very much. It seems to be importing now...
0
 
LVL 22

Expert Comment

by:plusone3055
ID: 39984435
Excellent
Happy Coding
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sql Audit table 3 96
Query to return total 6 26
Please help for the below sql query. 1 34
Migrate SQL 2005 DB to SQL 2016 4 32
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

734 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