DTS bulk import into SQL Server, then query away as usual. DTS is incredibly fast, and there are tutorials (google pengowrks and dts) on how exactly to set it up using stored procedures and CF.
On 6/12/07, Les Mizzell <[EMAIL PROTECTED]> wrote: > > I've got a vendor that's going to FTP product data files directly into a > folder on a site. From there, I need to be able to run several different > queries on this to come up with a list of PIN numbers which then get > used elsewhere. > > I got my first glimpse at one of the 'files' yesterday. It's a 75 to 80 > meg CSV text file! They FTP a new one once a week. > > What would be considered "best practice" in handling this file so i can > run queries on it? Import the needed bits into a database (still a big > chunk of data)? Something else? > > You can't directly query a CSV file, correct? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280764 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
