Solved

SQL Server - Cannot import Access table

Posted on 2014-04-07
14
435 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Where clause in stored procedure 8 60
Sql Query join multiple table and distinct records 7 31
SQL query to summarize items per month 5 71
sql query help 2 57
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

839 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