A
arno
Hello,
Excel 2003
I have been using ADO to query Access Databases (which contain only of
ODBC-links) for ages. Now I try to setup the same configuration (here
Firebird database linked to an Access 2002 mdb) in another company. Running
the queries from Excel 2003 works, however, copyfromrecordset takes 5min to
finish for 2 fields and 1000 records. Does somebody know why this can take
so long and how to speed it up?
The same query in Access works in a second. (The query in the Excel macro is
also very fast, only the line with copyfromrecordset takes ages.) So, we
have here a problem of Excel and not of the configuration of databases,
servers, odbc, etc., right?
regards
arno
Excel 2003
I have been using ADO to query Access Databases (which contain only of
ODBC-links) for ages. Now I try to setup the same configuration (here
Firebird database linked to an Access 2002 mdb) in another company. Running
the queries from Excel 2003 works, however, copyfromrecordset takes 5min to
finish for 2 fields and 1000 records. Does somebody know why this can take
so long and how to speed it up?
The same query in Access works in a second. (The query in the Excel macro is
also very fast, only the line with copyfromrecordset takes ages.) So, we
have here a problem of Excel and not of the configuration of databases,
servers, odbc, etc., right?
regards
arno