Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How to convert Access tables into SQL server database/tables

Posted on 2012-04-10
2
Medium Priority
?
250 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
2 Comments
 
LVL 9

Accepted Solution

by:
wasiftoor earned 2000 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

783 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