Re: Is it possible to export data from access to MySQL?
Download MySQL-Font v2.5 This is what I used when I switched from Access to MySQL. Once installed just load MySQL-Front and click on Im-/Export on the toolbar. Select ODBC Import. Viola! On Tue, 26 Nov 2002 16:37:45 +0200, Steve Jackson wrote: Is it possible to export data from MS Access into MySQL? If so how? I have a huge amount of data that will take weeks to input and I've convinced my boss to use MySQL rather than any other DB because of it's compatibility with PHP. However I (probably hastily) *assumed* that there would be a way to export the data. Any ideas? Steve Jackson Web Developer Viola Systems Ltd. http://www.violasystems.com [EMAIL PROTECTED] Mobile +358 50 343 5159 - 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 --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- - 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: Is it possible to export data from access to MySQL?
I ran across several quick and dirty, but very effective little converters at this site: http://www.intranet2internet.com Regards, Jim Jim Esten Chief Techbot WebDynamic http://www.wdynamic.com -Original Message- From: Steve Jackson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 26, 2002 8:38 AM To: MySQL General Mailing list Subject: Is it possible to export data from access to MySQL? Is it possible to export data from MS Access into MySQL? If so how? I have a huge amount of data that will take weeks to input and I've convinced my boss to use MySQL rather than any other DB because of it's compatibility with PHP. However I (probably hastily) *assumed* that there would be a way to export the data. Any ideas? Steve Jackson Web Developer Viola Systems Ltd. http://www.violasystems.com [EMAIL PROTECTED] Mobile +358 50 343 5159 - 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: Is it possible to export data from access to MySQL?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Steve, It is quite possible. You can use MyODBC to connect your current Access database(s) into your MySQL server directly, the major drawback is that you'd have to create the overall table structure in MySQL first and then link the table from MySQL into Access through the File|External Data|Link Table... Menu. Or you can find and download DBTools which will export your tables for you into MySQL. I use MyODBC to connect some of my users to MySQL through Access, as that was the easiest route for my end-users. HTH, Bryant H. Hester - -Original Message- From: Steve Jackson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 26, 2002 8:38 AM To: MySQL General Mailing list Subject: Is it possible to export data from access to MySQL? Is it possible to export data from MS Access into MySQL? If so how? I have a huge amount of data that will take weeks to input and I've convinced my boss to use MySQL rather than any other DB because of it's compatibility with PHP. However I (probably hastily) *assumed* that there would be a way to export the data. Any ideas? Steve Jackson Web Developer Viola Systems Ltd. http://www.violasystems.com [EMAIL PROTECTED] Mobile +358 50 343 5159 -BEGIN PGP SIGNATURE- Version: PGPfreeware 7.0.3 for non-commercial use http://www.pgp.com iQA/AwUBPeOJiklWu7/HFp4nEQLL8gCdGyKJWMwrVjqnyUczHBQswrt2xIYAoMJH H2FttK0BuepoUPFNby40uuGP =Yty5 -END PGP SIGNATURE- - 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: Is it possible to export data from access to MySQL?
Cheers. Sorted very quickly using MySQL front. Good thing is I can use that to get the SQL and then cut and paste it to any DB I like which is PDG! Steve Jackson Web Developer Viola Systems Ltd. http://www.violasystems.com [EMAIL PROTECTED] Mobile +358 50 343 5159 -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED]] Sent: 26. marraskuuta 2002 16:42 To: MySQL General Mailing list; [EMAIL PROTECTED] Subject: Re: Is it possible to export data from access to MySQL? Download MySQL-Font v2.5 This is what I used when I switched from Access to MySQL. Once installed just load MySQL-Front and click on Im-/Export on the toolbar. Select ODBC Import. Viola! On Tue, 26 Nov 2002 16:37:45 +0200, Steve Jackson wrote: Is it possible to export data from MS Access into MySQL? If so how? I have a huge amount of data that will take weeks to input and I've convinced my boss to use MySQL rather than any other DB because of it's compatibility with PHP. However I (probably hastily) *assumed* that there would be a way to export the data. Any ideas? Steve Jackson Web Developer Viola Systems Ltd. http://www.violasystems.com [EMAIL PROTECTED] Mobile +358 50 343 5159 - 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 --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- - 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: Is it possible to export data from access to MySQL?
MySQL-Front is quite good for this... - Original Message - From: Steve Jackson [EMAIL PROTECTED] To: MySQL General Mailing list [EMAIL PROTECTED] Sent: Tuesday, November 26, 2002 4:37 PM Subject: Is it possible to export data from access to MySQL? Is it possible to export data from MS Access into MySQL? If so how? I have a huge amount of data that will take weeks to input and I've convinced my boss to use MySQL rather than any other DB because of it's compatibility with PHP. However I (probably hastily) *assumed* that there would be a way to export the data. Any ideas? Steve Jackson Web Developer Viola Systems Ltd. http://www.violasystems.com [EMAIL PROTECTED] Mobile +358 50 343 5159 - 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: Is it possible to export data from access to MySQL?
A quick way. If you don't have phpMyAdmin running set it up. It has a great import feature. Just dump the access table to a delimited text file. Then go to phpMyAdmin, from the main page - create a new database, or select an existing one. from there scroll down to create a table, enter the table name and amount of fields. Enter all field names and types. Save it, then scroll down to Insert data from a textfile into a table and follow the instructions. Its a piece of cake from there. Steve Bradwell MIS Department. If you give someone a program, you will frustrate them for a day. If you teach them how to program, you will frustrate them for a lifetime. -Original Message- From: Steve Jackson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 26, 2002 9:38 AM To: MySQL General Mailing list Subject: Is it possible to export data from access to MySQL? Is it possible to export data from MS Access into MySQL? If so how? I have a huge amount of data that will take weeks to input and I've convinced my boss to use MySQL rather than any other DB because of it's compatibility with PHP. However I (probably hastily) *assumed* that there would be a way to export the data. Any ideas? Steve Jackson Web Developer Viola Systems Ltd. http://www.violasystems.com [EMAIL PROTECTED] Mobile +358 50 343 5159 - 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: Is it possible to export data from access to MySQL?
Hi! Yes, it's possible. Export your Access data to standard csv files, and then use mysqlimport with appropriate parameters to import the csvs into MySQL. The MySQL manual has excellent guidance on using mysqlimport or LOAD DATA INFILE statements (which can do the same as mysqlimport). Iikka On Tue, 26 Nov 2002, Steve Jackson wrote: Is it possible to export data from MS Access into MySQL? If so how? I have a huge amount of data that will take weeks to input and I've convinced my boss to use MySQL rather than any other DB because of it's compatibility with PHP. However I (probably hastily) *assumed* that there would be a way to export the data. Any ideas? Steve Jackson Web Developer Viola Systems Ltd. http://www.violasystems.com [EMAIL PROTECTED] Mobile +358 50 343 5159 - 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 Iikka Meriläinen Vaala, Finland E-mail: [EMAIL PROTECTED] - 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: Is it possible to export data from access to MySQL?
I used MyAccess to convert my 40mb .mdb file into MySQL and it works great. You can find it and a whole bunch of other conversion tools on the MySQL site in Downloads/Other. Here's the link, http://www.mysql.com/downloads/os-win32.html Good Luck Steve Jackson [EMAIL PROTECTED] 11/26/02 6:37:45 AM Is it possible to export data from MS Access into MySQL? If so how? I have a huge amount of data that will take weeks to input and I've convinced my boss to use MySQL rather than any other DB because of it's compatibility with PHP. However I (probably hastily) *assumed* that there would be a way to export the data. Any ideas? Steve Jackson Web Developer Viola Systems Ltd. http://www.violasystems.com [EMAIL PROTECTED] Mobile +358 50 343 5159 - 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: Is it possible to export data from access to MySQL?
you're gonna get lots of neat high tech answers to your problem, so here's a low tech answer just because it's fun. construct the database in mysql. copy the access database to a working copy to be safe. in the working copy, link to the mysql tables. open the access table a and copy the data. open the mysql table a and paste the data. : ) the kid in me loves doing that. copy and paste is the most powerful concept in windows. the only reason that i don't use it in corereader is that it would permanently tie corereader into ms. windows. Is it possible to export data from MS Access into MySQL? If so how? I have a huge amount of data that will take weeks to input and I've convinced my boss to use MySQL rather than any other DB because of it's compatibility with PHP. However I (probably hastily) *assumed* that there would be a way to export the data. Any ideas? Steve Jackson Web Developer Viola Systems Ltd. http://www.violasystems.com [EMAIL PROTECTED] Mobile +358 50 343 5159 -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ - 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: Is it possible to export data from access to MySQL?
I like that one. Steve Bradwell MIS Department. If you give someone a program, you will frustrate them for a day. If you teach them how to program, you will frustrate them for a lifetime. -Original Message- From: John Ragan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 26, 2002 12:50 PM To: MySQL General Mailing list; [EMAIL PROTECTED] Subject: Re: Is it possible to export data from access to MySQL? you're gonna get lots of neat high tech answers to your problem, so here's a low tech answer just because it's fun. construct the database in mysql. copy the access database to a working copy to be safe. in the working copy, link to the mysql tables. open the access table a and copy the data. open the mysql table a and paste the data. : ) the kid in me loves doing that. copy and paste is the most powerful concept in windows. the only reason that i don't use it in corereader is that it would permanently tie corereader into ms. windows. Is it possible to export data from MS Access into MySQL? If so how? I have a huge amount of data that will take weeks to input and I've convinced my boss to use MySQL rather than any other DB because of it's compatibility with PHP. However I (probably hastily) *assumed* that there would be a way to export the data. Any ideas? Steve Jackson Web Developer Viola Systems Ltd. http://www.violasystems.com [EMAIL PROTECTED] Mobile +358 50 343 5159 -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ - 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: Is it possible to export data from access to MySQL?
Dear Steve, Is it possible to export data from MS Access into MySQL? If you don't care to export every single table manually, this is what you do: 1. Install MyODBC 3.51.04 2. Configure a system DSN for your MySQL server. 3. In Access, right-click the table to be exported. 4. Choose Export... 5. Choose Data Type ODBC. 6. Choose a name for the table (default: the Access name). 7. On Computer Data Source, choose the DSN you set up in step 2. The table will be created in the database you set up in step 2. The export will create the table definition (.frm) and import the data. Make sure _all_ your Access tables have primary keys, this makes things easier. You may run into trouble if your Access tables have strange column names (e.g., with spaces, umlauts etc.). Recently, I tried this procedure on a 500 MB Access table with 1.2 million records, and it took 4 minutes on a 2 GHz single processor Pentium machine running Win2K with Service Pack 2. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Steve Jackson [EMAIL PROTECTED] To: MySQL General Mailing list [EMAIL PROTECTED] Sent: Tuesday, November 26, 2002 3:37 PM Subject: Is it possible to export data from access to MySQL? Is it possible to export data from MS Access into MySQL? If so how? I have a huge amount of data that will take weeks to input and I've convinced my boss to use MySQL rather than any other DB because of it's compatibility with PHP. However I (probably hastily) *assumed* that there would be a way to export the data. Any ideas? Steve Jackson Web Developer Viola Systems Ltd. http://www.violasystems.com [EMAIL PROTECTED] Mobile +358 50 343 5159 - 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
