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

Please help me

Regards
Tina

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.