Solved

SQL Server - Cannot import Access table

Posted on 2014-04-07
14
436 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
  • 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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

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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Help with SQL joins 9 56
How to use TOP 1 in a T-SQL sub-query? 14 48
date diff with Fiscal Calendar 4 75
Stored Procedure needs owner to execute 5 44
If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

685 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