This works just fine, but I would like to do it from a java class instead. I
have set up a JDBC connection so I can query the database from my java application. But is it possible to call the the VB-script from java, or create the bulk load (which is a stand alone COM object) directly in java? or can I somehow call the VB-script from a stored procedure in SQL Server?
This turned out to be maybe a java-question more than a sql server question, but all help would be greatly appreciated!
Sounds like you'd be better served placing the bulk insert into a DTS package since you already have a connection into your SQL server. I may be off base here but with my experience with SQL this is the route I'd take. Probably not the answer you wanted to hear.