Paul, Yes, I've just done an import into multiple sheets in the same workbook with no problem
Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Newton Sent: 17 August 2007 11:08 To: [email protected] Subject: Re: Excel question Dave IIRC the 65536 limit applies to worksheets not workbooks? So one should be able to use this method multiple times (with chunks of 65536 records) and put each chunk in a different worksheet in the same workbook Paul Dave Crozier wrote: > Paul, > I've just done some tests and imported a .dbf file of 7Mb so there is no > problem there in terms of file size. > > However, the limit of 65536 records is still there though and anything after > that is ignored and its quick to import. > > Dave Crozier > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Paul Newton > Sent: 17 August 2007 10:39 > To: [email protected] > Subject: Re: Excel question > > Dave Crozier wrote: > >> Andy, >> Using Jaime's method doesn't involve any export/import of physical data >> files. >> >> > Dave > > With that method will one still have to create multiple (16K/64K) > recordsets ? > > Paul > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
