Re: [AccessDevelopers] Exporting to excel 65000+ records

[Toby Bierly]

I'm thinking of two possible ways to break up the table into chunks.  I take that back, the second way wouldn't work because you can't delete the Top n records.  Here's the first way:   1.  Add a column and programatically fill it with sequential numbers ********************** Dim rst, i Set rst = CurrentDb.OpenRecordset("Select newcolumn >From tablename") i = 1 While Not rst.EOF     rst.Edit     rst!newcolumn = i     rst.Update     i = i + 1 Wend **********************     Then you can export to Excel certain ranges of the table.  For instance, for the first chunk: "Where newcolumn > 0 and newcolumn <= 65000"       Delete the newcolumn when you are done exporting.   If you only need to do this once, some of the steps can be done manually.  If you want the whole thing to be automatic, you've got some work ahead of you.  I haven't tinkered enough with exporting to Excel to know how to automatically create spreadsheets.   HTH, Toby ----- Original Message ----- From: Manuel Tejada To: AccessDevelopers@yahoogroups.com Sent: Monday, December 19, 2005 11:05 AM Subject: RE: [AccessDevelopers] Exporting to excel 65000+ records Do you know of any way to automate the creation of the spreadsheets?   Thanks,   Manuel Tom Oakes <[EMAIL PROTECTED]> wrote: I don't think there's a way to exceed that limit, but I'm pretty sure that's per worksheet - so, like you said just split the data to separate sheets.   Tom Oakes Personal PC Consultants, Inc. [EMAIL PROTECTED] 503.230.0911 (O) 402.968.6946 (C) 734.264.0911 (F) From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Manuel Tejada Sent: Monday, December 19, 2005 8:33 AM To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] Exporting to excel 65000+ records Hi all, Is there any mechanism that I could use when exporting table/query that has more than 65,536 records? I am thinking in something like expliting the data in different spreadsheets.....Any idea?   Thanks,   Manuel __________________________________________________ Do You Yahoo!? Tired of spam? Yah! oo! Mail has the best spam protection around http://mail.yahoo.com __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Spam Not spam Forget previous vote Please zip all files prior to uploading to Files section. SPONSORED LINKS Microsoft access developer Microsoft access help Microsoft access database Microsoft access training Microsoft access training course Microsoft access programming YAHOO! GROUPS LINKS  Visit your group "AccessDevelopers" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.