Solved

SQL Server - Cannot import Access table

Posted on 2014-04-07
14
439 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
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 
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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

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

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

636 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