EXCEL2000 - ODBC Links

  • Thread starter Thread starter jjj
  • Start date Start date
J

jjj

Hi, I have an excel sprdsht which has lots of refreshable links in it t
Access97 queries, that then create tables of data within the sprdsht i.
"Get External Data" function.
However, the Access DB has now moved to a different loation and so th
sprdsht doesn't refresh saying "..db...does not exist". Is ther
anyway to update the sprsheets so I can tell it where all the dat
sources now are by typing in the full path? Rather than re-building al
the individual "get External data" queries.

Please help
 
Sorry, but you are in a jam. when created as Part of the
MSQ (Mircosoft Query/get external date) records the file
path to the data sorce as part of the query. if you have
move the data sorce, then all the MSQ's will have to be re-
written. There may be code to do this but i don't know it.
the quickest way to do is would be to open the MSQ in
design mode. In design mode, click the SQL icon. this will
show you the code. enter the new file path. copy the new
file path, open all the other MSQ's you have, and paste
the new file path of the old.
 
Back
Top