copying loads of data fron a text file to a table 
Author Message
 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



Mon, 13 Oct 2003 00:04:33 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. edit: copying loads of data fron a text file to a table

2. export data from an Access table to a text file via vbScript

3. Text File (fixed-length) to load Table

4. Copy text file contents to database table?

5. Copy text file contents to database table?

6. Loading Text Files into Access Tables

7. Batch Copy a large text file into a SQL table

8. Copying DBGrid contents to clipboard (Or copying a table from a Data component to clipboard)

9. Copying Table text to tables

10. Thank you (how to load data to a text file

11. how to load data to a text file

12. Copying data from table to table

 

 
Powered by phpBB® Forum Software