| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create ODBC link Using VBA
Phil,
Yes you do, or if you have an oracle database I think there is a way to do it in the tnsnames.ora file but I don't know it off the top of my head. The setup for a System DSN through the ODBC settings will vary depending upon the database management system used and the driver version... "pspyve" wrote in message ... Thanks Dove for your reply. I really appreciate it. Using this set up, Do you need to set up a system DSN in the computers ODBC settings(ODBC Data Source Administrator), as this is my issue? Phil S -- pspyve ------------------------------------------------------------------------ pspyve's Profile: http://www.excelforum.com/member.php...o&userid=30656 View this thread: http://www.excelforum.com/showthread...hreadid=561885 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing ODBC link in a query | Excel Discussion (Misc queries) | |||
| link ODBC connection to an Oracle database | Excel Discussion (Misc queries) | |||
| Creating ODBC link within SELECT statement | Charts and Charting in Excel | |||
| paste special keep odbc link | Excel Discussion (Misc queries) | |||
| ODBC Link to db with custom modules | Excel Discussion (Misc queries) | |||
Threaded Mode
