Scott Hamm wrote:
Ok. I'm looking into alternatives. I'm trying to figure out an alternative
to mysql exporting into xls file.
Gosh, what's wrong with CSV files? Surely Access can export a classic CSV file format with fields separated by commas and enclosed by ""?
Then you can just use
LOAD DATA INFILE file.csv INTO TABLE whatever
FIELDS TERMINATED BY ',' ENCLOSED BY '"';Of course, you still have the problem of creating the appropriate equivalent tables in mysql, but I'm sure you can dump the schema in Access and massage the output to create the schema in MySQL.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
