Try SQLyog - www.webyog.com
I use the ODBC Import Facility regularly.
regards
Karam
--- Arjun Subramanian <arjun@stripped> 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:casey@stripped]
> Sent: Thursday, March 18, 2004 6:32 PM
> To: mysql@stripped
> 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
> Casey@stripped
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
>
http://lists.mysql.com/mysql?unsub=1
>
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
>
http://lists.mysql.com/mysql?unsub=1
>
__________________________________
Do you Yahoo!?
Yahoo! Mail - More reliable, more storage, less spam
http://mail.yahoo.com
