Yea! Just so you know...I always use import/export specs. They give you much more control over just TransferText without one.
Bill
---In MS_Access_Professionals@yahoogroups.com, <ms_access_professionals@yahoogroups.com> wrote:
Sent from my mobile device
On Sep 28, 2013, at 12:29 PM, "Bill Mosca" <wrmosca@comcast.net> wrote:
Patty
Start a manual import. When you get to the wizard there is a checkbox to skip the first row. When you get it set up the way you want click on the Advanced button and save the setup as a Spec. Then you reference the spec in the DoCmd.TransferText command as one of the arguments.
Regards,
Bill
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Patricia Mapes
Sent: Friday, September 27, 2013 2:39 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] DoCmd.TransferText
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 (6) |
Tidak ada komentar:
Posting Komentar