Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ODBC with UNC - data into MS Excel 2000 from MS Access 2000.
I found a solution! From my controlpannel in Win98 I made a File-DSN called “xx” using a mapped drive-letter the usual way. Then I found the file xx.dns on my harddisk in C:\….\ODBC\Data Sources. It’s a textfile and I just changed the drive-letter to “\\ip\share” and a new database. It looks... -
ODBC with UNC - data into MS Excel 2000 from MS Access 2000.
How do I set up ODBC without mapping the server using UNC to get data into MS Excel 2000 from MS Ac-cess 2000? I have tried on Win98 and WinXP and can’t find a way to do it. In MS Query I can se the 'from' when viewing the query in SQL-mode and I can change drive-letter to UNC, but then I get...
