
copying loads of data fron a text file to a table
At the moment I am doing this manually. A txt file consists of 965 email
addy's. these are ppl who have registerd to my newsletter via a Perl script.
The mail addy's are copied into this txt file by he script.
I want to transfer the newsletter stuff to my own VBScript mail application.
I need the emails inside a database.
Each email addy must go into a sepperate field.
[txt file]
...
...
etc
[/txt file]
I know VBScript is perfect for automating stuff like this. but how would I
go about this?
Build a VBS function that retrieves each addy and posts it into a table.
Can be, posting straight the Access2000 database, or having the mailaddy's
get posted into an HTML table or Excel sheet is all the same to me. As long
as the result consists of something that can be imported into Access easely.
Any info is very much appreciated
thanks in advance
Jim