odbcconf

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am looking for an example of how to add a Excel file as a ODBC datasource.
I need to do this from the command line. I think the utility odbcconf is
meant for this but i cant seem to find either the documentation or any
examples that i can use.

thx
-anish
 
http://www.connectionstrings.com/

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
|I am looking for an example of how to add a Excel file as a ODBC
datasource.
| I need to do this from the command line. I think the utility odbcconf is
| meant for this but i cant seem to find either the documentation or any
| examples that i can use.
|
| thx
| -anish
 
Thanks a ton Dave but I am really challenged here. Assume i have an excel
file here called test.xls what is the specific command to make this a data
source?
I know the connection string you pointed to is key - but i have no clue on
how to use that connection string.
thx,
-anish
 
For anyone interested the actual command i used was:
odbcconf configdsn "Microsoft Excel Driver (*.xls)"
"DriverId=790|Dbq=e:\anish\regression.xls|DefaultDir=e:\anish|DSN=ANISHXYZ|description=yada yada"

For connection strings for other datasources, pls look at the site dave
pointed to.

thx
-anish


Anish said:
Thanks a ton Dave but I am really challenged here. Assume i have an excel
file here called test.xls what is the specific command to make this a data
source?
I know the connection string you pointed to is key - but i have no clue on
how to use that connection string.
thx,
-anish


Dave Patrick said:
http://www.connectionstrings.com/

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
|I am looking for an example of how to add a Excel file as a ODBC
datasource.
| I need to do this from the command line. I think the utility odbcconf is
| meant for this but i cant seem to find either the documentation or any
| examples that i can use.
|
| thx
| -anish
Click to expand...
Click to expand...
 
Back
Top