I need to link to the SQL server Remedy2 table T86. Anyone have any ideas how I can achieve this in Excel as I am stumped! Webmaster of The EPICentre and owner of Minatures Online. (10% off all VOID goods!)
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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Data Source Control in Excel
- Thread starter thehead
- Start date
Confirm that you have the proper ODBC driver installed
then
From menu...
Data>Get external data>New database Query...
select your driver or DSN which ever is applicable...
follow the wizard from there...or select cancel (after you have defined the table(s) to query) to switch to "MsQuery" to invoke an Access like GUI for building queries.
then
From menu...
Data>Get external data>New database Query...
select your driver or DSN which ever is applicable...
follow the wizard from there...or select cancel (after you have defined the table(s) to query) to switch to "MsQuery" to invoke an Access like GUI for building queries.
- Status
