QUERY a Text file having no headings 2

[SkipVought]

Occasionally I have a text file with no headings. It is too large to import into Excel.

I'd like to be able to have a file that has a single record containing the headings nad append to the text file, in order to QUERY the combination and return a subset of data using MS Query or ADO.

Is it possible to do this in the connect string, or will I have to actually create one combined text file first?

Skip,

_{To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white]}

 

[CautionMP]

SkipVought,
Would using ADO with the [tt]Microsoft Text Driver[/tt] and a [tt]Schema.ini[/tt] work for you?

[tab]ConnectionStrings.com > Textfile
[tab]MSDN > Schema.ini File (Text File Driver)

Hope this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)

 

[SkipVought]

Thanks, CMP. Exactly what I was looking for!

Skip,

_{To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white]}