David Mineer wrote: > I have an app that uses DTS in MSSQL server to export records to a > ..dbf file that is then emailed or made available to our clients. > Using DTS has never been ideal for me and now we are moving to a > hosted solution with workgroup edition of MSSQL which as I understand > it doesn't have DTS included. > > What are my options for exporting to a .dbf or .csv file(Other than > DTS). I imagine that these would be the two most universal choices, > with .csv being the more universal. > > Is anyone else out there doing this type of exporting. How are you handling > it?
1. I usually do it directly from the database (but I use PostgreSQL): COPY users TO 'd:\users.csv' WITH CSV; 2. If that isn't an option I use CF: http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:49577#265066 Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268602 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
