SQL SERVER QUESTION

[omarswan]

Hi,
Please keep in mind that I have never user SQL SERVER
before.

If I created a database using MS Access 97 or 2000, is there
a way that I can convert it so that it can be used in SQL
SERVER without loosing any data that was previously entered?

If so what are the steps?

Thanks

[asabi]

Sure you can do it.

in the SQL server, you right click on the DataBase folder.
choose "All Tasks"-->import data

in the source: choose "microsoft access"-->next
destination: choose <new> in the DB and type a name for the new databse-->next-->next-->next-->finish


and that's it, you suppose to have everything..

ask if you have any questions .. :-)

[omarswan]

Thanks