BCP or Bulk Insert - using a DTS Package On 6/7/07, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > > I had a similar problem to solve once. What I did was create a macro that > imported the data into an Access database. I set up a DSN for that access > database with a predefined file name, and gave the end user an interface > to > upload their identically named Access database (the data structure was > always the same). Ripping through a delimited text file took nearly 3 > hours, while using the access database instead took a matter of minutes. > The performance difference really was quite striking. > > Pete > > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280470 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
