i am linking vb (v6.0) to a mysql (v1.4) database successfully using ado.

i am trying to write vb code to import a text file to the database.

im having a problem because mysql will force the text file in and just display warnings, this is fine when i do it from the mysql prompt but is there any way i can view these warnings from vb?????

i have been trying to pipline the output from mysqlimport to a text file to read back but am having difficulties because command.com conflicts with the " and \n in my arguements.

im sure someone knows the answer...