On 10 Jul 2004 02:32:31 -0700, (Jamie Collins)
wrote:

Mike A wrote ...

I think that you need to change your path in the DSN (Data Source
Name).

DSN? The OP didn't mention one. Rather, it may be the connection
string that requires amending. See:

http://www.dicks-clicks.com/excel/Ex...htm#ChangeConn

Jamie.

It was a shot in the dark - the OP may have created a new DSN the
first time MS Query was used, not realizing that it is not part of the
query (it is a setting for the local OS) and will not be
copied/updated with the query or the workbook.

From the link you posted:

....the Connection string may contain a DefaultDir element that points
to a path. You don't necessarily have to change the DefaultDir, but
if the directory that exists there doesn't exist on your hard drive,
you will get an error...

Another possibility!


Mike Argy
Custom Office Solutions
and Windows/UNIX applications

Please post on-topic responses to the newsgroup

To e-mail me, remove nospam from the address in the headers