just use CF to call a DTS using CFEXECUTE -----Original Message----- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: 20 November 2002 15:40 To: CF-Talk Subject: Importing a text file into SQL Server table
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? I already have the cffile code in place looking at the text file. Thanks, Bruce ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
