Results 1 to 2 of 2

Thread: PLEASE HELP! Data Control Uses Field Names!?

  1. #1

    Thread Starter
    New Member
    Join Date
    Aug 1999
    Location
    UK
    Posts
    13

    Post

    I am accessing a text file with a data control, but it uses the first row as field names and I don't want it to - how do I correct this??

    Thanks in advance

    ------------------
    Chris Keeble
    www.giglist.com
    mailto:[email protected]

  2. #2
    New Member
    Join Date
    Aug 1999
    Posts
    5

    Post

    As far as I am aware there are three ways of getting around this:

    1. Edit the following key in the registry
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\Engines\Text and change the FirstRowHasNames to 00. You may need to look at a slightly different area in the registry depending on your VB/JET version.

    2. Make a schema ini file, this describes to jet dbengine various things about your text file. Search for more info on this option under vb's help.

    3. Or if all else fails don't use JET to access the text file at all. Use the OPEN and LINE INPUT functions, etc. ... pants I know but can be handy as a last resort.




    ------------------
    MGC
    [email protected]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width