Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Read text File

Status
Not open for further replies.

lonchi

Programmer
Jan 30, 2002
12
MX
Does any one know what I need to do to read a specific *.text file and insert some data in a database!

The text file will look like this:
===================================
Set:1
Name: My name
Adress: My adress
Street: My street
Zip: My Zip

Set:2
Name: My name
Adress: My adress
Street: My street
Zip: My Zip

Set:3
Name: My name
Adress: My adress
Street: My street
Zip: My Zip
.
.
.
.... and so on!
==================================
The information of a single person has to be inserted in a database.

Can anyone help?
tnx
 
You can use the microsoft .txt odbc driver and it works fine, but it expects the data to be vertical like this:

field1field2field3field4

I do not know how you would go about accessing data where the fields are on separate lines like in your post. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office
 
You should change working with txt files in working with xml files. I'm doing it with another reporting tool Formscape and I'm planning to do the same with Crystal whcih I just received last week.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top