read text file

J

John

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,777
Messages
2,569,604
Members
45,227
Latest member
Daniella65

Latest Threads

Top