Text Data Parse

[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

[Herfried K. Wagner [MVP]]

* "Ken Barz" <an*******@discussions.microsoft.com> scripsit:

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?

<http://www.connectionstrings.com>
-> "Text"

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
<http://www.mvps.org/dotnet>

[Tom Leylan]

"Ken Barz" <an*******@discussions.microsoft.com> wrote...

I would like to create a program that parses data in
either a text or csv file and then sends it to a
database.

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