How to convert Access tables into SQL server database/tables

noamco36
noamco36 used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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
Most Valuable Expert 2014

Commented:
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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial