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]
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
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]
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+mysql&hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=tchs8rl5phqib7%40corp.supernews.com&rnum=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
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]
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]
