Thread: list of extended properties for use with ADO connection strings
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Loane Sharp Loane Sharp is offline
external usenet poster
  
Posts: 28
Default list of extended properties for use with ADO connection strings
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


Reply With QuoteReply With Quote