Hello list. I have a text file that is comma and double-quote separated, with a line break that separates the lines. The first row contains the header information. What I am wanting to do is to import this into a SQL Server 2K table. I know that I can use DTS to do this, but I need to do this in ColdFusion code instead as a scheduled task. I have always in the past just used DTS Wizard to do this, not straight SQL. So, my question is, how do you import a text file into SQL Server? What would my query look like?
Thanks, Bruce ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Get the mailserver that powers this list at http://www.coolfusion.com
