• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 500
  • Last Modified:

transfertext - If using an import spec, is a header record required, it seems so.....

Hi EE,

transfertext  - If using an import spec, is a header record required, it seems so.....

pls advise, tx, sandra
  • 4
  • 3
1 Solution
Simon BallCommented:
i think there is an option box to tick when creating the spec to say wether a header record is required.

if you create a spec, you are defining what the column names will be in the spec.  what makes you say "it seems so?"
mytfeinAuthor Commented:
hi sudonim,

tx so much for writing...

i will go check if there is an option box for a header....

i created an import specification and experimented:
   - import with header - got all following data records
   - import w/o  header - first record did not get imported, so guessed that access
                                       considered the first record a header record

this file is provided by a vendor w/o a header, so let me see if i can find the tick box that you mention...

will be back, tx, s
mytfeinAuthor Commented:
Hi Sudonim,

ok, you inspired me...

the specs window does not have a box to skip the header
    if manually doing an import, it does ask if you have a header

but as i want to do this thru vba,
    went back to code, which i copied off the internet, and there is a TRUE/FALSE parameter
     for field names:

so i set to False:

DoCmd.TransferText acImportDelim, _
      "match_results_136 Import Specification", _
      pg_strTableName_ThisYear_NRMP, _
      Me.txtFolderPathText, _


will go test it, tx, s
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

mytfeinAuthor Commented:
Hi Sudonim,

yes... FALSE is what it needed....

tx again, s
mytfeinAuthor Commented:
Dear EE public,

Sudonim's questions and help, jogged my brain to understand where the solution may be...
so pls read lower to what i posted to the technical solution....

tx, s
Simon BallCommented:
nicely done.

I don't really deserve the point, but you've put me 2% closer to sage, so many thanks :)
Simon BallCommented:

If you'd mentioned you were using VBA in the original question, i'd have looked into that bit too :)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now