RE: [AccessDevelopers] Exporting to excel 65000+ records

[Manuel Tejada]

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? Yahoo! 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


Please zip all files prior to uploading to Files section.

---

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.

---