Solved

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

Posted on 2012-03-14
7
491 Views
Last Modified: 2012-08-13
Hi EE,

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

pls advise, tx, sandra
0
Comment
Question by:mytfein
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 15

Accepted Solution

by:
Simon Ball earned 500 total points
ID: 37720841
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?"
0
 

Author Comment

by:mytfein
ID: 37720871
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
0
 

Author Comment

by:mytfein
ID: 37720906
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, _
      False


http://msdn.microsoft.com/en-us/library/aa220768(v=office.11).aspx

will go test it, tx, s
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:mytfein
ID: 37720919
Hi Sudonim,

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

tx again, s
0
 

Author Comment

by:mytfein
ID: 37720937
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
0
 
LVL 15

Expert Comment

by:Simon Ball
ID: 37723786
nicely done.

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

Expert Comment

by:Simon Ball
ID: 37723792
also,

If you'd mentioned you were using VBA in the original question, i'd have looked into that bit too :)
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question