Import Specification

M

Mike Painter

John said:
How do I write and save a text file import specification?
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.
 
Top