Access into SQL

Hi
I have a MS Access database on the DASP server and now wish to migrate all the tables/data into a DASP SQL account (presumably SQL 2005 will be fine?). I would be grateful if anybody could tell me how to do the migration (preferably without having to do anything on a local machine since all the data is on a DASP server and needs to stay on a DASP server in the SQL database)

Many thanks
Nick

 

Hi,
This is somewhat of a loaded topic since Access can do some things SQL Server does not support.
If however all you need so to migrate your tabels and records you should be fine. Procedures as well.
I have used it in a long time but Access has a Upgrade wizard for getting your Access data into SQL Server.
That would definately be the best way to do it but a local instance of SQL Server can also import Access.
To do it on the server would require a lot of code, reading from the Access DB and then populating your SQL DB.
Which ever way you'd like to do this I can help, no problem.
Salute,
Mark