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]
Printable View
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]
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]