mysql import
mysql import
HiThis is possibly not possible with this tool.I am using it to import some files from the web:http://xyz.com/myfile.csvThis works fine but I would then like to automate the Import to mysql.I am using navicat and of course can go to import it there.Is thjere a way of writing a sql statement or usign this robot to import the files?thanks for any help
mysql import
I think yes, it's possible.
You can download .CSV file from the site and process it within Text loop.
Also, if you want to use MySQL database you have to install ADO or ODBC drivers for MySQL ( look for links at http://dev.mysql.com/ )
You can download .CSV file from the site and process it within Text loop.
Also, if you want to use MySQL database you have to install ADO or ODBC drivers for MySQL ( look for links at http://dev.mysql.com/ )