>-----Original Message----- >From: Mario Madunic [mailto:[EMAIL PROTECTED] >Sent: Saturday, October 13, 2007 3:39 PM >To: [email protected] >Subject: How to insert CSV into SQL Server via ANT > > >Hi I've been using the BCP command to do this via ><exec executable="bcp"> > <arg ..... myCSV.txt ></exec> > >Ran into a problem with this. I thought bcp was a standard >install on PCs but it >is only installed with SQL Server or SQL Server Express. Is >there an ANT task >that can do this? > >Marijan (Mario) Madunic
Hello Mario, You could use the <sql> task to run sql INSERT statements against your db (you still need to turn your CSV files into sql insert statements, but that shouldn't be too hard), but then the machine on which you are running will need the JDBC drivers for SQLserver, so not sure if that helps much. Regards, /t --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
