opening merge data source

[rbyteme]

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.

 

[Susanne Wenzel]

Am Fri, 24 Nov 2006 14:25:01 -0800 schrieb rbyteme:

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.

Maybe you find something useful here:

http://www.connectionstrings.com/

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.

This may be an option. I think that depends on how much you are familiar
with building the query that delivers you the resultset you need. Something
only you can know.

Did you have a look at this?:

*(den folgenden Link bitte in /eine/ Zeile)*
http://groups.google.de/group/micro...enzel"+publisher+2006&rnum=1#8174f3832345532a

Thank you to anyone who can help.

I don't know whether I could, but at least I tried.

Greetings
Susanne