Hi all,
Using the import wizard to bring a text file into a dbf works perfectly for my particular situation.
Step2 identifies the file as being DELIMITED
Step2a identifies the FIELD DELIMITER as being TAB and the TEXT DELIMITER as DOUBLE QUOTES.
The resulting dbf has all the data correctly formatted and in the appropriate fields.
However, when attempting to achieve the same results with an APPEND statement, the dbf does not format the fields correctly in all cases. Meaning some records append correctly while some have columns that do not line up properly, off by one or two.
Using the wizard as a guide, I issued the command...
append from mytext.txt delimited with " with tab
...in the attempt to bring the text file into my dbf.
Looking into the text file, I noticed that the problem records are missing a field or two delimited by "". So I imagine that is the reason for the misalignment of the columns. But why does the import wizard handle this while the append statement does not?
Also, is there any way to or has anyone created a way to call the import.prg and pass it parameters, thereby circumventing the UI that appears? I would like to be able to automate the importing without having the user see the Forms.
Thanks in advance.