Connection String

T

td

A parameter for the .connect string for a linked text filed is
HDR=NO
I assumed this is to indicate whether a header line for the field names is
present. However, when linking a text file with a header row the parameter
seems to be set to NO.
Text;DSN=ImportSpec;FMT=Delimited;HDR=NO;IMEX=2;CharacterSet=850;

So...
What is HDR for?
Also I just omit IMEX and CharacterSet but what are they?
Thank you
td
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Read from Internet file 0
CONNECT String for a Linked table 0
unknow link specifications 8
testing for password in ADODB connection. 0
mailmerge recorded macro 0
ADO connection to Excel 2007 *.xlsx files? 8
How to create a Linked (text) table in xl vba to a .mdb 0
How to, using Excel VBA, link a text file to a .mdb file? 0

Top