Maximum Records You can Export

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JanetF - 19 Aug 2005 19:03 GMT

Hello,

I have a query with 280,000 records in it that I need to export to a text
file. When I try to do it, though, I get an error message saying that
Notepad can only hold 65,000 records so I'll have to export the rest of my
records separately. Is there any way around this? Thanks.

Janet

Reply to this Message

Douglas J. Steele - 19 Aug 2005 19:27 GMT

I've never seen an error message from Access that mentions Notepad. What's
the exact error message you get, and what are you doing when the message
occurs (i.e.: if you're running code, what's the code, or if you're working
through the GUI, what menu option have you selected)?

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hello,
>
[quoted text clipped - 4 lines]
>
> Janet

Reply to this Message

Ken Snell [MVP] - 19 Aug 2005 19:28 GMT

I just exported a table containing 349.471 records into a text file using
File | Export process in ACCESS.

No problems. What are you trying to do? I also replied to another message
you posted in another newsgroup. Let's stick to just one of these posts, ok?

Signature

Ken Snell
<MS ACCESS MVP>

> Hello,
>
[quoted text clipped - 4 lines]
>
> Janet

Reply to this Message