RE: [PHP] Conversion from access to mysql

Yea have downloaded MyODBC for windows, installed it and tested it out..... Have got a little further than last time, at least its pulled some of the tables across but with no data in them... mysql chucks up errors saying that there are errors in your statements, so how on earth do you change the way the exporter puts together its statements??? you dont I think ! -----Original Message----- From: Scott Houseman [mailto:scotth@jamwarehouse.com] Sent: 16 September 2002 10:20 To: Chris Grigor Cc: PHP Gen (E-mail) Subject: Re: [PHP] Conversion from access to mysql Hi Chris. You could try installing MyODBC on your SQL Server machine, create an ODBC connection to your mysql server, and then use SQL Server's "Import and Export Data" tool to export the database from yout SQL server to the Mysql server. Regards -Scott Chris Grigor wrote: > > > > Howdi All > > I posted this last week, and some of you had some suggestions and none of > them have worked.... > > I have a database running on an Sql 2000 Server, I want to take this > database and export it > so that it can be used on a MySql Linux server running version 3.23 > > I have tried exporting it to a text file, to an xls file and then using > dbtools > > Anyone else have any good ideas this is the first time I am doing it... > > Cheers > > Chris > > > > -- //--------------------------------------------// // Scott Houseman // // Jam Warehouse http://www.jamwarehouse.com/ // // Smart Business Innovation // // +27 21 4477440 / +27 82 4918021 // //--------------------------------------------// -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php