edit: copying loads of data fron a text file to a table 
Author Message
 edit: copying loads of data fron a text file to a table


When I open the TXT file from my server. the structure is as follows (dont
know if this might help)

(the * sign is actually a weird black sqaure in the textfile. This might
represent a line break, I m not sure)

> 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
> 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
> 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
> get posted into an HTML table or Excel sheet is all the same to me. As
> as the result consists of something that can be imported into Access

> Any info is very much appreciated

> thanks in advance

> Jim

Mon, 13 Oct 2003 00:08:44 GMT  
 [ 1 post ] 

 Relevant Pages 

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

2. Editing text file to create data file.

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

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

5. Copy text file contents to database table?

6. Copy text file contents to database table?

7. Loading Text Files into Access Tables

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

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

10. Checkbox to Edit Table Row Data.

11. Copying Table text to tables

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


Powered by phpBB® Forum Software