ODBC Connection error when linking Excel to Access to SQL database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: PG (PG_at_discussions.microsoft.com)
Date: 09/02/04 

Date: Thu, 2 Sep 2004 05:05:08 -0700

I'm trying to link Excel to an Access query where the Access query is linked
to an external database through a SQL ODBC connection.

The query will run perfectly in Access but when run indirectly through
Excel( by using import external data) Microsoft Query returns an odbc
connection failure.

The connection it fails on isn't the Excel-Access connection but the
Access-SQL connection.

Relevant Pages

  • Re: Pass MailMerge.CreateDataSource to document from Access
    ... Running a macro in my Word 2003 environment showed the script I will use. ... >> with mailmerge back to my Access query as the data source. ... Test the available connection methods for the Office version involved. ...
    (microsoft.public.office.developer.automation)
  • Re: cant get next number
    ... multiple times - it appears the first insert is not picked up by the ... next select max- even using the same connection. ... Access query using the same ... Are you running in auto commit mode? ...
    (comp.lang.java.databases)
  • DSN Behaving Badly
    ... the two connections required for an Access query. ... (The other connection uses the PostGRE SQL connection and works as ... When I created the DSN, I specified that it should use SQL Server ... However, when I attempt to run the query, I get a "Connection Failed" ...
    (comp.databases.ms-access)
  • Using Access Queries???
    ... How do i setup a connection that looks at a access query instead of a table? ... is a query assigned a command.type = "StoredProcedure" when setting up the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Accessing external database causing problems?
    ... Make sure the backgroundquery property is set to false would be my guess. ... > I have a spreadsheet that accesses an external database. ... I'm guessing that the connection to the ... > I can easily work around this issue by creating a copy of of the file, ...
    (microsoft.public.excel.programming)