View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jamie Collins Jamie Collins is offline
external usenet poster
 
Posts: 593
Default 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.

--