SQL query within a dsn file ?
- From: "Patrice Dargenton" <patrice.dargenton@xxxxxxx>
- Date: Fri, 21 Oct 2005 12:39:04 +0200
Hi all,
is it possible to specify a SQL query within a dsn file ?
for example like this :
[ODBC]
DRIVER=Microsoft Excel Driver (*.xls)
UID=admin
UserCommitSync=Yes
Threads=3
SafeTransactions=0
ReadOnly=1
PageTimeout=5
MaxScanRows=8
MaxBufferSize=2048
FIL=excel 8.0
DriverId=790
DefaultDir=C:\Excel
DBQ=C:\Excel\ExcelFile.xls
SQL=Select * From [Sheet1$]
Thanks.
-------------------------------------------------------
Patrice Dargenton
patrice.dargenton@xxxxxxx
http://patrice.dargenton.free.fr/index.html
-------------------------------------------------------
.
- Prev by Date: Re: "Mask" Column Names
- Next by Date: Re: "Mask" Column Names
- Previous by thread: "Mask" Column Names
- Next by thread: SQLSetPos returning HY106 "Fetch type out of range"??
- Index(es):