tags:

views:

13

answers:

0
Q: 

Is there a way to use ODBC drivers for an Excel spreadsheet while Excel has the spreadsheet open?

I have been told that there is a bug in the Excel ODBC drivers, that prevents ODBC from providing updates while Excel has the spreadsheet open. Can someone tell me if this is true? Is there a known work-around?

Thanks, Ken

related questions

C++ SQLBindParameter
What Oracle driver should I install in my MS SQL server to be able to use DTS to copy data from the Oracle server to the MS SQL server?
Tool: ETL from an ODBC to SQL 05?
What is the simplest, most maintainable way to create a SQL Server ODBC Data Source?
How do I create a Jet ODBC link to a SQL Server view with periods in the field names?
Microsoft.ApplicationBlocks.Data.ODBCHelper ?
What are the access restrictions on accessing a DSN
.NET ODBC Connection Pooling
ODBC Connection Pool
what is the difference between OLE DB and ODBC data sources?
Reading a COBOL DAT file
Reverse Engineering for Database Diagramming in Visio with SQL Server 2008
How to programmatically configure an ODBC Datasource using C#
Best way to debug an ODBC driver on Windows
What is a Privileged instruction?
Control which columns become primary keys with Microsoft Access ODBC link to Oracle
How do you deal with NULL values in columns of type boolean in MS Access?
Using Rails 2.x with MS SQL Server 2005
C# ODBC Dialog
How do I get ms-access to connect to ms-sql as a different user?
How can I lock down my MS-SQL DB from my users and yet still access it through ODBC?
Using MySQL on Visual Studio 2008
Using MS Access & ODBC to connect to a remote PostgreSQL
Using Parameters in MS Reporting Services (SQL 2008) against an ODBC data source
Connect PHP to an AS/400