text file reading

  • Thread starter Thread starter Barrett Bonden
  • Start date Start date
B

Barrett Bonden

want to open a text file , read it and take comma seperated data and place
them into fields.

Playing with opentextfile (from scriptingfilesystemobject), but cant find
documentation on what to do next on the MS site.
I seem to recall an older method, but cant find docs on this either...
Once I can read the file stream, I think I can work out the rest .....
 
Barrett Bonden said:
want to open a text file , read it and take comma seperated data and
place them into fields.

Playing with opentextfile (from scriptingfilesystemobject), but cant
find documentation on what to do next on the MS site.
I seem to recall an older method, but cant find docs on this either...
Once I can read the file stream, I think I can work out the rest .....
Click to expand...


Are you a Patrick O'Brian fan, Bonden?

If you're dealing with comma-separated data, maybe it would be simplest
just to import it using the text import wizard: File -> Get External
Data -> Import..., Files of type: Text Files. Let the wizard take it
from there.

That's the easiest way to do it, if your text data has a consistent
structure.
 
I use the DOCMD.TRANSFERTEXT command to import comma delimited text files on
a regular basis.
I will send post a sample code if required.
 
Back
Top