excell driver

Results 1 to 2 of 2

Thread: excell driver

  1. #1
    Join Date
    Dec 1969

    Default excell driver

    can anybody help me with this connection string its driving me nuts. I keep getting the error "invalid charater.<BR><BR>&#060;%<BR>Dim strDatabaseType<BR>strDatabaseType = "Access"<BR>&#039;strDatabaseType = "sql"<BR>If strDatabaseType = "excel" Then<BR><BR>strConnect =_T("Driver={Microsoft Excel Driver (*.xls)};DriverId=790;<BR> bq=C:\C:InetpubwwwrootWebsitesDatabase\webinfo.xls ;DefaultDir=c:\C:InetpubwwwrootWebsitesDatabase;") ; <BR> <BR> Else<BR> strConnect = "Provider=sqloledb;Data Source=;Initial Catalog=;User Id=;Password=;"<BR> End if<BR>%&#062;<BR><BR>Thanks for any help

  2. #2
    Join Date
    Dec 1969

    Default Why do you..

    .. double up some of the characters?<BR><BR>strConnect =_T("Driver={Microsoft Excel Driver (*.xls)};DriverId=790;<BR>DBQ=C:C:InetpubwwwrootWe bsitesDatabasewebinfo.xls;DefaultDir=c:C:Inetpubww wrootWebsitesDatabase;")<BR><BR>Also, you may want to try the site, www.able-consulting.com/ado_conn.htm for connection strings.<BR><BR>Lastly, what does the function, _T() do?<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts