Export Access to Excel

[qing]

Hi,
I've tried to export the table in access to excel. But somehow if i have
about 650k of data, after I've export to excel, it only take successful
exported out 65k of data. Is there anyway that I can export everything out
into the excel?

Thanks.

 

[Klatuu]

Not in one pass. You are hitting the limit of the number of rows an Excel
worksheet con contain in versions through 2003. In 2007, the limit is (I
think) 1 million.

How you break it into pieces will depend you how your data is structured.

 

[Pete D.]

You don't say what versions your using but it sounds like your hitting
limits in excel. Versions vari so check by version both excel and access as
older versions of access will only export what excel can take.
http://office.microsoft.com/en-us/excel/HP051992911033.aspx