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]