I attempting to do a dns-less connection to an excel obdc
has any one done this using a connection string like
Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=C:\MyExcel.xls;DefaultDir=c:\directory;
Can you provide a simple example of how you used it because I am at a lost how to use it
Thanking you all in advance
DNS less - access Excel odbc
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You'll always need a DNS (or some other way of resolving host names to IP addresses).
Whether or not you need a DSN (data source name) is a different question.
Whether or not you need a DSN (data source name) is a different question.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.