D
dmv
I am using Excel with ODBC drivers. My company recently
upgraded our server to Win 2000. I had existing
worksheets that now give me an error when I try to Edit
Query. It says it can't find the Data Source.
If I try to create a New Query, I have no problem
grabbing the DSN. Is there somewhere on an existing
worksheet that I can see where it is pulling the data
from? I see on my Data Sources that there are 2 DSN's
with the same name and one has an *. I believe that
means that one is from a previous version. I'm trying to
see if my existing worksheet is using this one, but don't
know where to find this info. Does anyone know where I
can find and reset this??? Do I have to recreate my
spreadsheet?
Thanks for any help!
DMV
upgraded our server to Win 2000. I had existing
worksheets that now give me an error when I try to Edit
Query. It says it can't find the Data Source.
If I try to create a New Query, I have no problem
grabbing the DSN. Is there somewhere on an existing
worksheet that I can see where it is pulling the data
from? I see on my Data Sources that there are 2 DSN's
with the same name and one has an *. I believe that
means that one is from a previous version. I'm trying to
see if my existing worksheet is using this one, but don't
know where to find this info. Does anyone know where I
can find and reset this??? Do I have to recreate my
spreadsheet?
Thanks for any help!
DMV