xml data vs. ODBC text driver

  • Thread starter Thread starter David
  • Start date Start date
D

David

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?
 
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!
************************************************
 
Thanks for that insight and information. But the question still remains for
me should I use the ODBC text driver and a cvs file or a xml file to store
the data in and run querys against.? Thank you.
 
Back
Top