Re: xml data vs. ODBC text driver

From: Cowboy (NoSpamMgbworld_at_comcast.netNoSpamM)
Date: 05/18/04 

Date: Tue, 18 May 2004 13:26:10 -0500

Excel can import XML data, but to have it "natively" open, you will need to
format the XML in Excel format. This is different from DataSet format, so an
XSLT transform is in order.

There are quite a few ways I can think of to get to CSV format, however.

1. Write your SQL Query to concatenate fields to the CSV format
2. Use DTS objects (data transformation) - NOTE: COM only for now
3. Create a repeater that runs records as CSV and change the mime type of
the page to text (this will not automagically open in Excel, but the output
could even be emailed.
4. For Excel output, software artisans has a neat component (.NET version
available)
http://officewriter.softartisans.com/officewriter-37.aspx 

-- 
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
************************************************
Think Outside the Box!
************************************************
"David" <david.pilgrim@hs.utc.com> wrote in message
news:Oe5CKtDPEHA.556@tk2msftngp13.phx.gbl...
> I have a VB app i'm trying to upgade. Should I use the ODBC text driver or
> the xml commands?  I currently write the data to a csv text file and use
> that as my data source. Would writing that to a xml be the new and improve
> way to do that? I have about 600 records in the csv text file. Can excel
> inport XML data?
>
>
>
Loading