That works too, but normally SQL commands to bulk load data require the file to load be on or visible from the DB server machine.
Sometimes that's a problem if you're just loading data from some undistinguished client on the network (DB admins often don't let the server "see out" on the network, for security reasons). -Dan Please excuse typos; composed on a handheld device. -----Original Message----- From: Denis Samson <[email protected]> Date: Fri, 18 Jun 2010 09:18:01 To: jsoftware programming forum<[email protected]> Subject: Re: [Jprogramming] bulk insert with ODBC (into MySQL db) Dan, I guess I'll try that! I've found a "LOAD DATA" command in MySQL that would seem to fit the bill... It's not as nice as an ODBC insert (well, "nice" could be a bit overblown, here!) but if it works, it's got the job! thanks, denis _________________________________________________________________ MSN Dating: Find someone special. Start now. http://go.microsoft.com/?linkid=9734384 ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
