Posted to microsoft.public.excel.programming

Loane Sharp Loane Sharp is offline

external usenet poster

Posts: 28

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
edit data connection properties	karenj900	Excel Worksheet Functions	1	January 11th 09 02:26 PM
How to find number of pairs of strings from list of strings?	greg_overholt	Excel Worksheet Functions	5	January 27th 06 10:42 PM
Updating Connection Strings	Matt	Excel Programming	2	May 21st 04 11:47 AM
Changing Connection Strings	Matt	Excel Programming	6	May 21st 04 11:45 AM
.net, excel, extended properties and dbnull	Mark Baer	Excel Programming	0	October 30th 03 03:49 PM

All times are GMT +1. The time now is 12:39 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us