Dumb Question. I need to move my data from their current access database to my new MySQL server through an ODBC connection. The tables on both ends are set up identially. I have added a linked table to the access database called EXPARTAB1. The data is in EXPARTAB. I tried: INSERT INTO EXPARTAB1 VALUES (SELECT * FROM EXPARTAB)
I have used exportSQL from CYNERGI which is a very simple script for access, but the file it creates is 125 Megs to add the data, and I can't easily work with that. Ugh! And I can't just UNLOAD/LOAD it all to a file like I did back in my Informix Days. It's gotta be simple, but this had been beating me up all day. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
