I am trying to get the OpenDataSource method to work and cannot seem to get
correct connection string. Connection is to comma-delimited text file with
headers, obviously doesn't use standard ADO connection strings, which are
only ones I know. pub doc is already set up for merge but location of data
file can change -- its being opened via Access code which knows location. I
tried using string returned from reading connection property but didn't work,
or I may be missing or using incorrect parameter for bstrDataSource, or
missing other parameter. Using 2002.

would it be easier if i used connection to mdb instead? i didn't want to go
there as filters will be required, planned to just dump needed records into
default .txt file.

Thank you to anyone who can help.