-
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 :)
-
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 .. :-)
-
Thanks