If you're just trying to get a .csv file out, I've often done it using CF, although, in a quick and dirty fashion this works just as well: using query analyzer, write your query and run it. In the results pane, select all, and copy. Open a new excel spreadsheet, and with your cursor positioned in cell A1, paste. This should result in the query results being in your spreadsheet. (The column headers will not be there though.) You can then save the excel spreadsheet as a .csv file.
> > 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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:268606 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
