Solved

How to convert Access tables into SQL server database/tables

Posted on 2012-04-10
2
239 Views
Last Modified: 2012-08-13
Hello:

I have a bunch of tables built in MS Access and I need to convert them into SQL server tables.

What is the best tool for that using a GUI?
0
Comment
Question by:noamco36
[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
2 Comments
 
LVL 9

Accepted Solution

by:
wasiftoor earned 500 total points
ID: 37830571
You can use SQL server data import export wizard.
You can start the wizard by using the following steps:
On the Start menu, point to All Programs, point toMicrosoft SQL Server , and then click Import and Export Data.

It should be able to take care of Access imports easily.

For details look at:

http://msdn.microsoft.com/en-us/library/ms140052.aspx
0
 
LVL 26

Expert Comment

by:Nick67
ID: 37832838
NO!

You should use the SQL Server Migration assistant for Access, here
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=28763

This is a far superior tool for moving an Access backend to SQL Server
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

749 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