I am trying to import a text file, using the DoCmd.TransferText acImportDelim method.
The text files that I need to import have first row field names which are delimited by " ".
The data is tab delimited.
What is occurring is that the first row is setting the pattern for how the data is delimited. After the first row is imported, each subsequent row is imported entirely into the first field/column of each subsequent row.
So, the first row is correctly delimited and populating the table, but all the following rows are not.
I don't need the first row, but I don't know how to start the TransferText at row 2, if that is even possible.
If someone has a suggestion for me, I would be grateful.
Thank you,
--
Patricia Mapes
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar