Text Data Parse

  • Thread starter Thread starter Ken Barz
  • Start date Start date
K

Ken Barz

I would like to create a program that parses data in
either a text or csv file and then sends it to a
database. I've always used SAS for something like this,
but I like the control that VB gives me over the whole
process. Does VB have any tools for doing this kind of
work, and is there a good reference that I might get to
learn how to do it?

Thanks
 
* "Ken Barz said:
I would like to create a program that parses data in
either a text or csv file and then sends it to a
database. I've always used SAS for something like this,
but I like the control that VB gives me over the whole
process. Does VB have any tools for doing this kind of
work, and is there a good reference that I might get to
learn how to do it?
Click to expand...

<http://www.connectionstrings.com>
-> "Text"
 
Ken Barz said:
I would like to create a program that parses data in
either a text or csv file and then sends it to a
database.
Click to expand...

Hi Ken: The question is a little vague. Do you mean well defined comma
delimited files that basically match tables in your database created by
processes that understand the format, datatypes and value ranges? Or "text"
like searching through e-mail messages, extracting values, conforming them
into something sensible and submitting that to a database? Or something
altogether different perhaps?

I've got a feeling the answer depends entirely on the nature of the data,
where it comes from, the business rules, etc. Like what if it encounters a
duplicate along the way or values are out of range or missing?

"Read a single line from a CSV file, pick out values, update database (and
repeat)" isn't much of a challenge, is there more to it?

Tom
 
Back
Top