SQL Server - Cannot import Access table

Got this error (see attach) when importing an Access table 2010 to the SQL Server 2005 using the Import/Export Wizard. Please help.
HNA071252Asked:
Who is Participating?
 
plusone3055Connect With a Mentor Commented:
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
 
plusone3055Commented:
greetings
you need to try attaching the error again its not part of your post
0
 
plusone3055Commented:
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
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
HNA071252Author Commented:
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
 
plusone3055Commented:
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
 
HNA071252Author Commented:
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
 
plusone3055Commented:
0
 
HNA071252Author Commented:
I'm sorry I didn't understand what's in the link. Can you please be more specific? I'm still learning.
0
 
HNA071252Author Commented:
So if I install this then I'll be able to import Access 2010 tables to the Sql Server 2005?
0
 
plusone3055Commented:
yes you can with this tool :)
0
 
HNA071252Author Commented:
I've installed the software, and refresh the license. What do I do next? How do I use it?
0
 
plusone3055Connect With a Mentor Commented:
here is a "manual" of sorts from our good friends at Microsoft :)

http://technet.microsoft.com/en-us/library/hh313051.aspx
0
 
HNA071252Author Commented:
This is great. Thank you very much. It seems to be importing now...
0
 
plusone3055Commented:
Excellent
Happy Coding
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.