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]

Reply via email to