Migrating Access databases to MySQL
Hello people ! I was hoping for some wisdom from the good folks on this list about moving databases from access to MySQL. I am aware of the brute force method of exporting in CSV format or tab delimited formats and using mysqlimport to move the tables. 1. I was wondering if there was a way to dump access databases in SQL queries like the mysqldump utility does ? 2. When exporting tab delimited values from access and using mysqlimport everything works fine except date columns. All the data moves except the date field which shows up zero's I mysql after I use mysqlimport. Does anyone have a clue on what might be happening? 3. Is there any way other than downloading some shareware third party programs to transfer my databases from access to MySQL ? I would appreciate any help at all. Thanks to everyone in advance ! Arjun Subramanian Georgia Tech Station 32003 Atlanta GA 30332 Cell: +404.429.5513 I'm MySQL certified. Are you? -Original Message- From: Casey Sheridan [mailto:[EMAIL PROTECTED] Sent: Thursday, March 18, 2004 6:32 PM To: [EMAIL PROTECTED] Subject: writing queries to get distinct results I have a table that has employee names, pay rates, and unique IDs. I want to select all of the distinct employee names, and if there are two employees with the same name, I want to be able to choose only one; the one with the highest pay rate. If there are two identical employee names with the same pay rate, I want to select the one that has the lowest unique ID number. Can anyone help me on how to write this query? Thanks! -Casey Sheridan [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Migrating Access databases to MySQL
Hi bob ! thanks for your quick reply. I did do a search on google. I bumped into a bunch of stuff that really lead nowhere. Do you have any specific sites or utilities in mind ? Arjun Subramanian Georgia Tech Station 32003 Atlanta GA 30332 Cell: +404.429.5513 I'm MySQL certified. Are you? -Original Message- From: Bob Ramsey [mailto:[EMAIL PROTECTED] Sent: Thursday, March 18, 2004 9:07 PM To: Arjun Subramanian Subject: Re: Migrating Access databases to MySQL Arjun Subramanian wrote: 3. Is there any way other than downloading some shareware third party programs to transfer my databases from access to MySQL ? I have seen free macros that create a text file you can import into mysql; it creates the tables and inserts all of your data. Do a google search, and if you still can't find anything let me know. bob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Migrating Access databases to MySQL
Arjun Subramanian wrote: Do you have any specific sites or utilities in mind ? Try the code posted in this newsgroup posting: http://groups.google.com/groups?q=macro+access+export+mysqlhl=enlr=ie=UTF-8oe=UTF-8selm=tchs8rl5phqib7%40corp.supernews.comrnum=3 It's a little long to post here. It is for Access 97, so it may need some tweaking There's also this project on freshmeat: http://freshmeat.net/projects/exportsql/ Another project called exportsql here: http://www.cynergi.net/exportsql/ I don't know if those two are the same or just have similar names. Another macro here: http://elmo.engineering.tech.nhl.nl/config/two/tools/access_to_mysql.txt It's been a long time since I used one of these macros and I can't remember which one it was that I used. You will probably have to do a little bit of tweaking if you have Access XP, but I don't know for sure. Bob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Migrating Access databases to MySQL
Try SQLyog - www.webyog.com I use the ODBC Import Facility regularly. regards Karam --- Arjun Subramanian [EMAIL PROTECTED] wrote: Hello people ! I was hoping for some wisdom from the good folks on this list about moving databases from access to MySQL. I am aware of the brute force method of exporting in CSV format or tab delimited formats and using mysqlimport to move the tables. 1. I was wondering if there was a way to dump access databases in SQL queries like the mysqldump utility does ? 2. When exporting tab delimited values from access and using mysqlimport everything works fine except date columns. All the data moves except the date field which shows up zero's I mysql after I use mysqlimport. Does anyone have a clue on what might be happening? 3. Is there any way other than downloading some shareware third party programs to transfer my databases from access to MySQL ? I would appreciate any help at all. Thanks to everyone in advance ! Arjun Subramanian Georgia Tech Station 32003 Atlanta GA 30332 Cell: +404.429.5513 I'm MySQL certified. Are you? -Original Message- From: Casey Sheridan [mailto:[EMAIL PROTECTED] Sent: Thursday, March 18, 2004 6:32 PM To: [EMAIL PROTECTED] Subject: writing queries to get distinct results I have a table that has employee names, pay rates, and unique IDs. I want to select all of the distinct employee names, and if there are two employees with the same name, I want to be able to choose only one; the one with the highest pay rate. If there are two identical employee names with the same pay rate, I want to select the one that has the lowest unique ID number. Can anyone help me on how to write this query? Thanks! -Casey Sheridan [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: Migrating Access databases to MySQL
Arjun The free DBTools DBManager can import Access databases directly to MySQL : http://www.dbtools.com.br/EN/dbmanagerpro.php Freddie -Ursprüngliche Nachricht- Von: Arjun Subramanian [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 19. März 2004 02:56 An: [EMAIL PROTECTED] Betreff: Migrating Access databases to MySQL Hello people ! I was hoping for some wisdom from the good folks on this list about moving databases from access to MySQL. I am aware of the brute force method of exporting in CSV format or tab delimited formats and using mysqlimport to move the tables. 1. I was wondering if there was a way to dump access databases in SQL queries like the mysqldump utility does ? 2. When exporting tab delimited values from access and using mysqlimport everything works fine except date columns. All the data moves except the date field which shows up zero's I mysql after I use mysqlimport. Does anyone have a clue on what might be happening? 3. Is there any way other than downloading some shareware third party programs to transfer my databases from access to MySQL ? I would appreciate any help at all. Thanks to everyone in advance ! Arjun Subramanian Georgia Tech Station 32003 Atlanta GA 30332 Cell: +404.429.5513 I'm MySQL certified. Are you? -Original Message- From: Casey Sheridan [mailto:[EMAIL PROTECTED] Sent: Thursday, March 18, 2004 6:32 PM To: [EMAIL PROTECTED] Subject: writing queries to get distinct results I have a table that has employee names, pay rates, and unique IDs. I want to select all of the distinct employee names, and if there are two employees with the same name, I want to be able to choose only one; the one with the highest pay rate. If there are two identical employee names with the same pay rate, I want to select the one that has the lowest unique ID number. Can anyone help me on how to write this query? Thanks! -Casey Sheridan [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Migrating Access databases to MySQL
Hi, Hello people ! I was hoping for some wisdom from the good folks on this list about moving databases from access to MySQL. I am aware of the brute force method of exporting in CSV format or tab delimited formats and using mysqlimport to move the tables. 1. I was wondering if there was a way to dump access databases in SQL queries like the mysqldump utility does ? 2. When exporting tab delimited values from access and using mysqlimport everything works fine except date columns. All the data moves except the date field which shows up zero's I mysql after I use mysqlimport. Does anyone have a clue on what might be happening? 3. Is there any way other than downloading some shareware third party programs to transfer my databases from access to MySQL ? You might want to try Database Workbench - it has a Schema transfer utility and datapump. Check www.upscene.com With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]