CODEWITHSUNDEEP
sql-serverms-access
Nandini
Nandini

Reputation: 393

How can I export my MS Access Data to SQL Server?

I have a MS Access database and I want to convert it to run on MS SQL Server.

How can I export it?

Upvotes: 2

Views: 4424

Answers (4)

Renaud Bompuis
Renaud Bompuis

Reputation: 16776

Use the free Microsoft SQL Migration Assistant for Access (SSMA): it's purpose is to convert Access apps to SQL: it's great and it's free.

I wrote a blog post about it:
http://blog.nkadesign.com/2009/ms-access-upsizing-to-sql-server-2008/

Upvotes: 0

Pablo Santa Cruz
Pablo Santa Cruz

Reputation: 181280

If your SQL Server is SQL Server 2000 or SQL Server 7, SQL Server Integration Services mentioned by Miles D was calles Data Transformation Services. By the way: I love this tool. It's awesome.

If for some reason you can't (or don't want to) use any of these tools, you could always write a very short piece of code (in Java, C# or whatever you feel comfortable with) to accomplish the same thing for your specific problem.

Upvotes: 0

Miles D
Miles D

Reputation: 8040

You can also use SQL Server Integration Services to import into SQL Server (2005), rather than export.

Upvotes: 4

gbn
gbn

Reputation: 432210

Tools.. Options... Upsizing Wizard, if I recall correctly.

Strictly speaking, you'll always need software to do it, unless you have 3 wishes from the ETL fairy.

Upvotes: 2

Related Questions