X-Original-To: pgsql-odbc-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 167053A43CB for ; Thu, 11 Nov 2004 01:28:17 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 95290-08 for ; Thu, 11 Nov 2004 01:28:05 +0000 (GMT) Received: from lakermmtao02.cox.net (lakermmtao02.cox.net [68.230.240.37]) by svr1.postgresql.org (Postfix) with ESMTP id C765F3A43F0 for ; Thu, 11 Nov 2004 01:28:05 +0000 (GMT) Received: from [192.168.0.9] (really [24.136.36.194]) by lakermmtao02.cox.net (InterMail vM.6.01.04.00 201-2131-117-20041022) with ESMTP id <20041111012804.COHG18789.lakermmtao02.cox.net@[192.168.0.9]>; Wed, 10 Nov 2004 20:28:04 -0500 From: Robert Treat To: David.Bear@asu.edu Subject: Re: [ADMIN] import limited to 1000 tuples Date: Wed, 10 Nov 2004 20:26:10 -0500 User-Agent: KMail/1.6.2 References: <20041110062116.GA486@asu.edu> In-Reply-To: <20041110062116.GA486@asu.edu> Cc: pgsql-odbc@postgresql.org MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <200411102026.10933.xzilla@users.sourceforge.net> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/30 X-Sequence-Number: 4644 On Wednesday 10 November 2004 01:21, David Bear wrote: > I am migrating data from msaccess. Using msaccess own export function > I was able to export to an odbc data source -- I chose the postgres > odbc source. The export went fine except it only save 1000 tupples > from the access data source. These are not real big tables, but they > do have almost 2000 tupples in them. Is there a limit to the number of > tupples that can be exported/created through the odbc driver? I'm fairly certain there's no limit in the ODBC driver (though I am re-directing to -odbc in case anyone tries to chime in), though I think I've hit this problem in access before. Is it possible for you to export to csv and then import the data in ? -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL