Re: xml data vs. ODBC text driver

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: David (david.pilgrim_at_hs.utc.com)
Date: 05/18/04 

Date: Tue, 18 May 2004 15:55:04 -0500

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.
"Cowboy" <NoSpamMgbworld@comcast.netNoSpamM> wrote in message
news:%23Kq6vWQPEHA.3264@tk2msftngp13.phx.gbl...
> 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?
> >
> >
> >
>
>

Relevant Pages

  • Re: Sane Syntax
    ... vital role in the future of TeX but we need some more human friendly ... Generating well formed LaTeX2e documents from XML ... Another approach is to convert existing documents to XML format and go ... TEI, together with DocBook, are the two ...
    (comp.text.tex)
  • Re: XHTML vs HTML
    ... to be the predominant type of HTML used on the web for many years yet. ... First, it is XML. ... XHTML is also ... transformed using XSL from and into virtually *any* other data format. ...
    (microsoft.public.frontpage.programming)
  • Re: text to bibliography?
    ... to xml: you can store binary data in an xml file. ... including your well-formattedbibliography(no longer in xml format). ... It is in annotated bibliographies (something Word 2007 does not ... that %I is actually the field representing the publisher. ...
    (microsoft.public.word.docmanagement)
  • Re: Future of LISP. Alternative to XML. Web 3.0?
    ... using s-expressions instead of XML, nobody is going to use it, ... because it's cheaper to keep the existing XML software and continue ... XML-MAIDEN format or to HTML format and next displayed via standard ... or a CanonML or LISP browser. ...
    (comp.lang.lisp)
  • Re: Data table text I/O package?
    ... It has bracketing: rows and columns. ... As a medium XML is as awful as readable. ... > tell you not to use an internal type when it suits your application. ... is irrelevant to the data format used. ...
    (comp.lang.ada)