I have a database currently in Access and understand it needs to be in SQL Server. I have been told by one developer that converting it is not necessarily straightforward, yet my previous coder says it only needs one extra line of code to point it ot SQL and it is as simple as that. Can anyone tell me how easy it really is to change from Access to SQL?

Many thanks.

You can open access file in MS Excel , save it as CSV file and then you can insert it into MS Sql or mysql

Hi

From within the SQL Server Enterprise manager you can use the import option. Right click the Database folder, then choose "Import Data" under the "All Tasks" Option. From this you can set the source to Microsoft Access and choose the MDB file and go from their.

Regards
Bill Button
Technical Manager
http://www.rodmatic.com

Originally Posted by clock

I have a database currently in Access and understand it needs to be in SQL Server. I have been told by one developer that converting it is not necessarily straightforward, yet my previous coder says it only needs one extra line of code to point it ot SQL and it is as simple as that. Can anyone tell me how easy it really is to change from Access to SQL?

Many thanks.

They're both right.

In MS Access, there's an "Upsizing Wizard" ( I think it's under the Tools menu ) that will convert an Access database into SQL format. It's pretty easy.

But both databases have concepts the other doesn't. SQL Server allows stored procedures to do pretty much anything you want, where Access "Action Queries" can only have one SQL statement each. But then Access lets you use macros, which can run a series of action queries one after the next - SQL Server doesn't have anything like macros.

So it really depends how complex the Access database is. If it's only tables and queries, then you should have no trouble. If it's got forms, macros, and so on, SQL Server doesn't support these concepts; you use a high level programming language to perform those kinds of tasks against a SQL backend.

Hope this helps.