Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    7

    Unhappy Unanswered: Connect to a Excel File using ADO

    How can I connect to an Excel file as a database using the ADO connection? The code below connect to an Access file. Do I have only to change the provider? What is the provider to an Excel file?

    Set ConexaoAccess = New ADODB.Connection

    With ConexaoAccess
    .Provider = "Microsoft.Jet.OLEDB.4.0"
    .Open ArquivoAccess
    End With

  2. #2
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    Here is a list of connection strings Excel is listed in there

    http://www.erlandsendata.no/english...badacconnstring
    HTH

    David

Posting Permissions

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