CSV/Bytearray to Datatable

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • B-Dog

    #1

    CSV/Bytearray to Datatable

    I'm trying to download a csv file into a datatable but can't seem to figure
    it out. I can read the csv into a bytearray and view it but I'm having
    trouble trying to figure out get the downloaded file into a datatable
    instead of saving the file to the hard drive then reading. I'd like to read
    it straight into the datatable. Any suggestions? Thanks



  • Cor Ligthert

    #2
    Re: CSV/Bytearray to Datatable

    B-Dog,

    This is quiet standard.

    See a sample of me in this message, however there are thousands.


    I hope this helps,

    Cor


    Comment

    • Bdog

      #3
      Re: CSV/Bytearray to Datatable

      That is, but is there a way to do it reading it straight from website using
      a bytearray without having to download the file then read it. Right now I'm
      using webclient to download into a byte array and can view the contents but
      haven't found a way to get it into a dataset. This process is fast if I
      could just figure out how to get it into a table.

      ByteArray = W.DownloadData( URL)
      ResponseString = System.Text.Enc oding.ASCII.Get String(ByteArra y)

      which gives me something like this

      ABC,ABC,123,456
      ABC,DEF,234,234
      ABE,SES,234,121


      "Cor Ligthert" <notmyfirstname @planet.nl> wrote in message
      news:el1jhhqWFH A.2060@tk2msftn gp13.phx.gbl...[color=blue]
      > B-Dog,
      >
      > This is quiet standard.
      >
      > See a sample of me in this message, however there are thousands.
      >[/color]
      http://groups-beta.google.com/group/...e1d7736d7f2a02[color=blue]
      >
      > I hope this helps,
      >
      > Cor
      >
      >[/color]


      Comment

      Working...