Hallo everyone,
I know that you with ASP can past a Excel-fil to SQL, but if the a program, which can upload the Excel-fil to a MySQL database!
Or is the another way, in which I can write MySQL-data, when I'm offline?
//Ulrik Q K
I'd try a COM(OLE) function that comes with PHP4.
http://www.phpbuilder.com/columns/alain20001003.php3
I'm Sorry my Engelsh, the = there and if = is!
Actually, it's pretty easy to upload a flat text file in tab delimited format and then read the file one line at a time and insert it into the database.
export your excell file into a tab delimited file and then use
INSERT LOCAL DATA FILE 'file.txt' INTO your_table
To get a tab delimited file back out, use
SELECT * INTO OUTFILE 'file.txt'
Look in the manual for more options to these commands:
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#LOAD_DATA
---John Holmes...
But don't forget, that's not portable between databases, while my method is. Choose accordingly.
How do you "export your excell file into a tab delimited file " at the command line?
What if I want this running in a .bat or .sh cron scheduler? I don't want to keep opening up and "Saving as.." every day. I want to automate it.
