Easy way:
Import the text file using the wizard.
Note the advanced button at the lower left (or right?)
Push it and you'll have the opportunity of modifying the spec or saving it
under another name.
Then use it with doCmd.transfertext
Harder way.
Use code to:
Open the data file,
open the table
Read a line or lines
Parse them
Put the items into a record.
I frequently import the textfile into a table as a flat file, then work on
it there.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
