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

read text file

P: n/a
I need to create an app to read text files and upload the data into SQL. The
text files are in different format so I want to run a method based on the
first line of my text files,

1. One of my text files look like this:
New Sales
BMW, VIN12345678989, 12122005,0,JSmith
Lexus, VIN98765432100, 01012004,1,JSmith

2. another text file looks like this;
Used Sales
BMW, VIN12345678989, 12122005,0,JSmith
Lexus, VIN98765432100, 01012004,1,JSmith

how can i run the New process if Line 1 = New, and run the Used process if
line 1= Used.
they actually go into two different tables, so I need a process for each.
The user will be allowed to upload these files via a web page on the
companies intranet

Feb 10 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.