Importing a file

[Eal]

I am wondering if it is possible to import data from an excel file which is used as a template. The data in the excell file could go in the different fields of different tables???

Thanks

[theeper]

Export the data into a CSV files, then use LOADFILE to put them into tables.

[Eal]

Thanks!
what about other way around? could you export a file from mysql table to excell as well??

[jkohns]

use

select * into outfile 'filename.xls' fields terminated by '\t' optionally enclosed by '"' lines terminated by '\n' from table....

versions later than Excel '97 will open it as a spreadsheet

also, an HTML-formatted table, minus the opening and closing <table> tags, will be opened as a spreadsheet by some later versions of Excel