Hi,

I have a access table, I want to read the record and create a external whatever.SQL file, so I can import to the MySQL server, the file will contain a whole bundle "INSERT statement"

I know how to get the record set from the access table, but just don't know how to write it to the text file with the correct format.

The sample record in the text.SQL file should like something below:

INSERT INTO `table1` VALUES ("","Johnny Knight","ABC Company","Tel: 309-432-3432","USA","50230","343550","106","16","0","0","0","logo.gif","1","0","0","0","","1","","0","","0", "0","1","0");


Thanks!