Exporting a table to Excel...

[Vandelay]

Hi,

I'm trying to export a table to excel.. there is about 45,000 records. when I do this, I get a message that 'records are deleted', and when I go to open up the excel file, there is nothing there (but the tab on the bottom is the right file name).

Help!

 

[dhookom]

What have you tried in terms of trouble-shooting?

I would try export the table to CSV. Then try open the csv file with Excel.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[SkipVought]

Vandelay,

I would suggest PULLING data into Excel using MS Query (Data/Get External Data/New Query - access files -- your access database ....)

Rather than the whole bloomin' table, you could use a parameter query and just retrieve the data that you'll need or not. It can automatically refresh when the workbook is opened.

Skip,

_{[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it!}

 

[Vandelay]

I don't know why, but I ran the 'compact and repair' and it solved the problem. I was able to export without problem.... sometimes you win with the simple tricks...

thanks..

Vandy