RE: [PHP] Importing MS Access into MySQL?
just what my problem was 2 month ago... here we go: http://dbtools.vila.bol.com.br/ this little toy will seat on your windows machine administering your mySQL database. It has an MSAccess-mySQL import feature very easy to use. Try to do so and check if your data went transferred ok. NOTE: You will need to review your MSAccess table structure, things like field names, properties and other attributes make yourself a copy first and play with it for a while ... but it is easy enough to do this way P.S: When I needed it that much I found a bunch of good advices in PHP-General Archives at http://marc.theaimsgroup.com/?l=php-general&r=1&w=2 Cheers, Maxim Maletsky -Original Message- From: James, Yz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 30, 2001 6:46 AM To: [EMAIL PROTECTED] Subject: [PHP] Importing MS Access into MySQL? Hey all, I heard somewhere (I think) that it's possible to import a Microsoft Access file (when saved as a delimited text file) into a MySQL table Just wondering whether or not this is true, and if it is, where I might find a tutorial / some literature on how I might go about doing it. Thanks, as always, in advance :) James. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Importing MS Access into MySQL?
There are a few ways to do this... 1) Save your data to a comma separated list and use the import features of mysql. This is the easiest option for one time use. 2) Use MyODBC, create a link table, and paste the rows into it. This is one of the easier options if you plan on doing it repeatedly. Jon Snell -Original Message- From: James, Yz [mailto:[EMAIL PROTECTED]] Sent: Monday, January 29, 2001 3:46 PM To: [EMAIL PROTECTED] Subject: [PHP] Importing MS Access into MySQL? Hey all, I heard somewhere (I think) that it's possible to import a Microsoft Access file (when saved as a delimited text file) into a MySQL table Just wondering whether or not this is true, and if it is, where I might find a tutorial / some literature on how I might go about doing it. Thanks, as always, in advance :) James. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Importing MS Access into MySQL?
Hey all, I heard somewhere (I think) that it's possible to import a Microsoft Access file (when saved as a delimited text file) into a MySQL table Just wondering whether or not this is true, and if it is, where I might find a tutorial / some literature on how I might go about doing it. Thanks, as always, in advance :) James. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]