Exporting records to Excel?

[scott]

Is there a way to increase the number of records that can
be exported with a macro to excel?

I have a large table with over 20,000 records and I keep
getting errors saying that I cant export all of them.

Thanks
Scott

 

[bukkybu]

-----Original Message-----
Is there a way to increase the number of records that can
be exported with a macro to excel?

I have a large table with over 20,000 records and I keep
getting errors saying that I cant export all of them.

Thanks
Scott
.

A very kind soul helped me with this very problem some
time ago. This link takes you to a Microsoft Product
Support page with a complete macro at the bottom of the
page. I just copied and pasted the entire macro, and it
worked like a charm.

http://support.microsoft.com/default.aspx?scid=kb;EN-
US;q120596

 

[scott]

This is really neat...But where do I put this code?

thanks

 

[bukky bu]

-----Original Message-----
This is really neat...But where do I put this code?

thanks
.

I'm no expert with Excel macros, so if there's a
better/easier way, I don't know it, but here's what I did:

Open a new excel spreadsheet.
Go to Tools/Macro/Record New Macro, name it and "Store
macro in" Personal Macro Workbook if you want it available
anytime you open excel.
Go to Tools/Macro/Stop Recording.
Go to Tools/Macro/Macros, highlight it and selected Edit.
Delete whatever may be on the visual basic screen, paste
the code there, File/Save, and close the visual basic
window.
Your macro should be ready to use.

 

[scott]

One more question then I will leave you alone.

If I am getting the error when I am exporting my table in
access to an excel file with a macro..how will this
putting this code in excel help this?

Wont I still get the same error in ACCESS when exporting
with a macro?

I am a little confused about that.

Thanks
Scott