Hi there

I want to use the LOAD DATA INFILE statement, but it seems that it only works for one table. I am going to receive a text file with many fields, and I need to specify which fields need to go into which table. So with one LOAD DATA I want to insert into more than one table.

Any suggestions?

Oh, I am using Visual C++ with Qt

Thanks
Cilna