joeybagadonutz
Regular
- Joined
- Nov 6, 2003
- Messages
- 72
Hi,
I have a text file that I need to read data from then import that data into a database table. Here is an example of what the data in the text file looks like:
12|field data|Rocky Mountains|
13|field data|Midwest|
14|field data|Rocky Mountains|New Mexico Event
As you can see, there are 4 columns...the last column is NULL in some cases and sometimes not.
How do I parse this text and update a database? Any example code is MUCHO appreciated thanks. I am thinking of like doing this with a script and having it run every 2 hours on my server, as the data in the text file will change every hour. So maybe an .aspx page would be perfect.
Oh, and I prefer to write code behind with VB. Thanks
-JBD
I have a text file that I need to read data from then import that data into a database table. Here is an example of what the data in the text file looks like:
12|field data|Rocky Mountains|
13|field data|Midwest|
14|field data|Rocky Mountains|New Mexico Event
As you can see, there are 4 columns...the last column is NULL in some cases and sometimes not.
How do I parse this text and update a database? Any example code is MUCHO appreciated thanks. I am thinking of like doing this with a script and having it run every 2 hours on my server, as the data in the text file will change every hour. So maybe an .aspx page would be perfect.
Oh, and I prefer to write code behind with VB. Thanks
-JBD