Export Access DB to MSSQL Server 2000

Hello,

I am working on a couple fo the ASP.NET walkthoughs and I would like to practice with a Database that I created in Access. I realize that I could use the Access DB, but I would like to learn to work with a more industrial strength DB. Is there a method to export to MSSQL server 2000 from Access ?

Regards,

JamesIf I remember correctly, use below steps to do that!

Open Enterprisemanager of SQLserver 2000, Open any database where you want to import access db table, then keep your cursor on Tables --> Right Click --> Select All Tasks --> ImportData --> Click Next --> Choose Microsoft Access from theData Source list box, and from there follow the steps in wizard, it will walk you through the steps to import AccessDB to that DB.

Hope it helps! [Note: You have to have permission to do this]|||I am actually using MSDE 2000. Is the process the same ?

Regards
James|||From access process should be same

I found a link at support on steps for it, please see and use that for exporting from access

Convert an Access Database to SQL Server

Hope it helps!|||Thanks

It Works !!