I have a text database which can be edited in excel or other database management program. Maybe even access.
Anyways, I have a database of 4000 users. I need each line in the database saved as individual files.
for example:
Here is one line in my text file
[login to view URL], vq8addjq, [login to view URL], Anthony J. Strohmayer, P.O. Box 8296, , Norfolk, VA, 23503, United States, , , , , , , , (444) 444-4444, (444) 444-4444, , 8/25/2003, 0, 12/9/2003, 16, Yes, -- -- , Good
I need it exported into a file which is saved as a (user name).dat file. first letter of the file name will be capitolized.
Will look like this when it is done:
vq8addjq
[login to view URL]
Anthony J. Strohmayer
P.O. Box 8296
Norfolk, Va 23503
444 444 4444
First line is the password
Second line is email address
Third is my name
Fourth is mailing address
5th is city, state, zip code
6th is telephone number
Additionally I need a second file saved in a seperate folder for the feedback ratings of each user.
Same save as (user name).dat with first letter of file being capitolized.
In this file the feedback rating is the only thing necessary. In this case the 16 is my feedback rating.
File format:
16
0
0