Make Table Query limitation
quartz wrote:
I find that when running a MTQ in MS-Excel against Oracle into an MS-Access
table, there is roughly a 10,000 record ceiling.
How are you connecting to the databases? Presumably your ADO connection
is to the target Access database. Are you connecting to Oracle via an
odbc connection embedded in the commandtext e.g.
SELECT *
INTO NewAccessTable
FROM [odbc;Driver=etc etc].OracleTable;
Are you using linked tables at all? Are you querying Oracle base
tables/VIEWs or invoking a stored proc?
Jamie.
--
|