How do I import data in SQL Server Management Studio Express 2005 from MS Access 200

Question

Sep 30, 2009, 04:08 AM

tinamartin

New Member

Join Date: Sep 2009

Posts: 1

How do I import data in SQL Server Management Studio Express 2005 from MS Access 200

Hi
In my ASP.Net project I am using SQL Server Management Studio Express. I have to import some datas from some tables which are stored in MS Access 2000. I couldnt find out Import/Export options in SQL Server Management Studio Express.

Please help me

Regards
Tina

Answers

Sep 30, 2009, 05:10 AM	#2

ScottGem

Computer Expert and Renaissance Man

Join Date: Jan 2003

Location: LI, NY - USA

Posts: 33,712

Pay to call ScottGem for advice ($.75/min)

First, Management Studio is a front end for managing data in SQL Server Express. So the database you are using is SQL Server Express.

Second, SQL Server Express is distributed by Microsoft as a free tool for developing and testing apps designed for SQL Server. So I'm assuming this ASP project is a school assignment. Otherwise it would be illegal to use SQL Server Express as a back end to a WEB site.

Third, the easiest way to get the data from Access to SQL Server is to create a ODBC DSN to your SQL Server database and then link the tables you want the data in within your Access database. Once you do that you can use Append queries within Access to get the data from the Access tables into the SQL Server tables.