SQL Query Help - Bulk Insert

[PGriffith]

@Sanderd17

The error seems to be about the first argument (@P0), so you should probably try with hardcoded arguments first, and then try to replace those by variables. I don't know to what extend the ?-replacement works with bulk inserts.

This is definitely it. You may not be able to run bulk insert as a prepared statement in this way (up to the JDBC driver, not Ignition); so you may need to use string substitution to insert the filename rather than a parameter substitute. There's some discussion on this topic here:

system.db.runPrepUpdate with variables

Yep… Baging my head on the desk now that I see. Thanks!! For some reason I was stuck on ‘%s’ method of replacing the variable instead of ‘?’.

Also, I cleaned up the code formatting on your post, but @Sanderd17 is definitely correct; wrapping in triple backticks (`) is the preferred way to post code.