RE: MS Access to MySQL conversion
Have a look at MyAccess available from http://www.accessmysql.com it has worked for me Alex -Original Message- From: andy thomas [mailto:[EMAIL PROTECTED]] Sent: 21 March 2002 09:14 To: [EMAIL PROTECTED] Subject: MS Access to MySQL conversion We have a Unix server which in addition to running MySQL is also a fileserver for a group of MS Windows PCs (using samba) and it would be useful to be able to convert the Microsoft Access .mdb files put there by users directly to MySQL, or at least to .csv format. Does anyone know of such a utility? Andy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.338 / Virus Database: 189 - Release Date: 14/03/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.342 / Virus Database: 189 - Release Date: 14/03/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MS Access to MySQL conversion
We have a Unix server which in addition to running MySQL is also a fileserver for a group of MS Windows PCs (using samba) and it would be useful to be able to convert the Microsoft Access .mdb files put there by users directly to MySQL, or at least to .csv format. Does anyone know of such a utility? Andy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MS Access to MySQL conversion? How?
I am new to this fast database and love MySQL, but I need to know how to import or convert Access database to MySQL. ANyone know how I would go about that? Also this is for a web site and I need to change the asp code to PHP. Its not a lot, only a few pages, but its a headache for someone that has never done it before Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MS Access to MySQL conversion? How?
try this: http://www.mysql.com/downloads/contrib.html#SEC653 -Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: Monday, October 22, 2001 2:12 PM To: [EMAIL PROTECTED] Subject: MS Access to MySQL conversion? How? I am new to this fast database and love MySQL, but I need to know how to import or convert Access database to MySQL. ANyone know how I would go about that? Also this is for a web site and I need to change the asp code to PHP. Its not a lot, only a few pages, but its a headache for someone that has never done it before Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.281 / Virus Database: 149 - Release Date: 9/18/2001 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.281 / Virus Database: 149 - Release Date: 9/18/2001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MS Access to MySQL conversion? How?
The Jonathan Tutorial Access -2- MySQL in 8 Not-Extremely-Easy-But-Not-Hard Steps 1. Go to mysql.com 2. Download and install MyODBC 3. Set up a new ODBC connection for the new mySQL server 4. Open up the database in access 5. Go to the File menu and choose to Export (Tables?) 6. At the bottom of the list of available formats to export to, there should be an ODBC data source or something to that effect. 7. You should be able to find the new ODBC connection you set up in step 3 using the dialog boxes that pop up. 8. Press OK and presto - your entire Access table structures and data are now in mySQL. Congratulations. - Jonathan -Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: Monday, October 22, 2001 2:12 PM To: [EMAIL PROTECTED] Subject: MS Access to MySQL conversion? How? I am new to this fast database and love MySQL, but I need to know how to import or convert Access database to MySQL. ANyone know how I would go about that? Also this is for a web site and I need to change the asp code to PHP. Its not a lot, only a few pages, but its a headache for someone that has never done it before Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MS Access to MySQL conversion? How?
I used MyAccess2000, it connects through ODBC inside Access. You can create tables, import Access to MySQL or MySQL to Access and it will display table SQL and indexes, its $30usd http://www.accessmysql.com/ -Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: Monday, October 22, 2001 5:12 PM To: [EMAIL PROTECTED] Subject: MS Access to MySQL conversion? How? I am new to this fast database and love MySQL, but I need to know how to import or convert Access database to MySQL. ANyone know how I would go about that? Also this is for a web site and I need to change the asp code to PHP. Its not a lot, only a few pages, but its a headache for someone that has never done it before Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
