Hi all
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: dk****@nusconsulting.com.au
website: www.nusconsulting.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw