Is there a simple way to convert an MS Access mdb database to MS SQL Server 2000 or MySQL?
N Noozer Aug 22, 2005 #1 Is there a simple way to convert an MS Access mdb database to MS SQL Server 2000 or MySQL?
D Douglas J Steele Aug 22, 2005 #2 What version of Access? There are Upsize Wizards available for both Access 97 and Access 2000: Access 97 http://www.microsoft.com/downloads/...07-7c5f-46cb-9157-a1ec4e96083d&displaylang=en Access 2000 http://www.microsoft.com/downloads/...60-3ed5-4e69-9c4f-3a34c1c4be7d&displaylang=en You can also use DTS (Data Transformation Services) from the SQL side. Take a look, too, at what SSW has at http://www.ssw.com.au/ssw/ Afraid I don't know for MySQL.
What version of Access? There are Upsize Wizards available for both Access 97 and Access 2000: Access 97 http://www.microsoft.com/downloads/...07-7c5f-46cb-9157-a1ec4e96083d&displaylang=en Access 2000 http://www.microsoft.com/downloads/...60-3ed5-4e69-9c4f-3a34c1c4be7d&displaylang=en You can also use DTS (Data Transformation Services) from the SQL side. Take a look, too, at what SSW has at http://www.ssw.com.au/ssw/ Afraid I don't know for MySQL.
