EXPORT MORE THAN 200000 RECORDS FROM ACCESS TO EXCEL

  • Thread starter Thread starter TITO
  • Start date Start date
T

TITO

I WANT TO EXPORT 200000 RECORDS FROM ACCESS TO EXCEL
WORKSHEETS DIRECTLY WITH OUT DIVIDING THE DATABASE INTO
65000 DIFFERENT RECORDS, IF ANY ONE FIND SOLUTION PLEASE
MAIL ME


THANKS

TITO
 
Sorry.. not possible with M$ Access. it has a row limit of 65536. Your
best bet is to try & put it in different sheets in the workbook. so, when
you get to the end of the 1st sheet... move to the 2nd.

Why on earth would you really & truely want to export 200000 records to
Excel? if you're going to export it... export it to some kind of SQL
server... & use access as the document editor thingy. Step up... not down.

if you are trying to export data to give to someone else... use a comma
separated document or something else & zip it & send it. Or just export the
data to another MDB & send that. You'll have much better success with that.

Hope that helps.
:)
 
Yes for the O.P.'s question but no for Douglas' statement which is true
regardless of the Excel versions.

IIRC, XL97 can accept 64K rows, not sure about XL2K or XLXP but I don't
think the limits have been changed.

--
Cheers
Van T. Dinh
MVP (Access)
 
Van T. Dinh said:
Yes for the O.P.'s question but no for Douglas' statement which is
true regardless of the Excel versions.

IIRC, XL97 can accept 64K rows, not sure about XL2K or XLXP but I
don't think the limits have been changed.
Click to expand...

Looks like you're right. I must have been remembering that earlier
versions were limited to a smaller number of rows; 16K, maybe?
 
I WANT TO EXPORT 200000 RECORDS FROM ACCESS TO EXCEL
WORKSHEETS DIRECTLY WITH OUT DIVIDING THE DATABASE INTO
65000 DIFFERENT RECORDS, IF ANY ONE FIND SOLUTION PLEASE
MAIL ME
Click to expand...

Just a couple of etiquette notes:

Typing in ALL CAPS is considered rude. It's hard to read and looks
like you're SHOUTING AT US.

Requesting private EMail responses is also rude. The volunteers who
answer questions here do so for the public; if it's worth my time to
log on and answer questions, it should be worth yours to come back to
the newsgroup for the answer.

To answer your question, the 64K limitation is in Excel: an Excel
spreadsheet simply cannot hold 200000 records. This is like asking
"How can I put two gallons into a quart bottle? And I don't want to
divide it into quart units!" So the answer is: you can't. There is no
solution that meets your demands.
 
65536 Rows continues to be the limit on the number of rows in Excel.
However, There IS a solution that will meet his needs.
Export the data into a CSV file.

Because it is flat text file, it can be as long as needed - indeed all 200K
rows can be placed in it.

If the file is opened in Excel, the user will get an error saying the file
could not be loaded completely,
and the poster can deal with that problem separately.

HS
 
Back
Top