By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,504 Members | 1,187 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,504 IT Pros & Developers. It's quick & easy.

Text Data Parse

P: n/a
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
Nov 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
* "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>
Nov 20 '05 #2

P: n/a
"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
Nov 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.