SQL LanguageSQL Language discussions not specific to a particular RDBMS program or vendor.
Welcome to the p2p.wrox.com Forums.
You are currently viewing the SQL Language section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
I do a bulk insert and it works if I have column 5 to varchar in the table or format file. But column 5 is a date in format
24-Feb-2004 12:00:00 PM EST
Which is all great other then the EST at the end kills me. If datatype is smalldatetime then it says bad conversion during bulk insert. But if I edit text file manually and delete EST then it all works fine. I need field to stay date for querying later. Is there a way to trim from the left (LEFT in VBScript) during a bulk insert? Or is there a way or datatype to use?