Access export to Excel

[Santee]

Why would a text file export from diskette into Access ok but when you try to export it from Access to Excel the data will not all export. You can break it into sections and export but can't send it as one export. The field sizes are not large. How can you tell if the data on the disk is corrupt before you enter it into Access?

 

[GIA]

Because Excel has a limit of 65,535 lines, which can not be beaten. "Outside of a dog, a book is probably man's best friend; and inside a dog, it's too dark to read" - G. Marx

 

[Santee]

The export has only 12000 lines. We can get it to export 4000 but not the 12000 it just locks the system and will never complete. Any suggestions?

 

[GIA]

It sounds like you've hit a bug, and whether you have or not, your dilemma is a frustrating one. We feel your pain. Well, please don't let this insult your intelligence, but sometimes it doesn't help to restate the obvious...

scandisk

repower the machine + 10 seconds (not just reboot)

isolate the offending record(s), if any, by breaking up into sections as you described

run Group By queries to see if weirdness appears in the data

try copying the table to another table (or make-tabling to another table) and try again.

The last suggestion shows my resignation to the power of voodoo, in some situations where only a supernatural solution appears to work! :-Q

Try to let us know if you figure it out. Again, "we feel your pain." -------
"What is your favourite colour?" "Blue! No! Yell"

 

[JohnCHolmes]

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q177991

XL: Limitations of Passing Arrays to Excel Using Automation

Credit this answer to Tom Ogilvy in Usenet.