View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default list of extended properties for use with ADO connection strings

Hi Loane

I'd start at Able Consulting:
http://www.able-consulting.com/tech.htm

Best wishes Harald

"Loane Sharp" skrev i melding
...
Hi there

I'm using ADO to connect between Access databases, Excel workbooks and

plain
text files. Do you perhaps know where I can get a full list of all the
extended properties for use with connection strings for text files:

strConnect = _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\TextFiles\;" & _
"Extended Properties=Text;" & _
"HDR=Yes;"

Best regards
Loane