I have some data in Excel ( I didn't put it there - a customer did ).
I'm setting up an import routine for it, with an Access front-end.
I don't like the way Access imports Excel files, though, and I'm thinking about getting the user who will import it to first open the spreadsheet and save it as a csv file.
Then I'll use mysqlimport on it.
Then the fun will begin. The data really is in a horrible format. The order of each row is important. Can I trust mysqlimport to import the data in the right order, or is it just by chance that that's the way it's happened so far?
Thanks!
-- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
