Exporting to Excel

[pvwdr]

I have a Access program that exports a table to Excel. It works fine except for one thing, not all of the data gets exported to the spreadsheet. 95% of the cells get populated but I can't figure out why the last 5% don't get there. Using Office XP PRO ... any ideas? If you need more info I would be glad to supply ... thanks, Bill

 

[GeorgeWNYC]

You don't really give enough to go on here. I remember that dates and times get a little funky in export.

Specify.

 

[pvwdr]

It is financial data, specifically an accounts receivable report. I have the total balance in one filed and then I have the aging buckets in other fields, i.e 0-30 days 30-60 days ... etc ... the balance comes over into excel fine, and most of the aging buckets come over too, but some of them do not.

I would have a client with a balance of 10,000 adn all of it in the 0-30 bucket in teh table but nothing in teh spreadsheet

 

[GeorgeWNYC]

what kind of object are you exporting, and how?
Is it a TABLE or a REPORT

 

[pvwdr]

Here is how I am transferring the table
DoCmd.TransferSpreadsheet acExport, , "tblTrueAR", folder & "TrueAR" & Format(Forms![frmMain]![txtPaymentDate], "mmddyy&quot & ".xls"

 

[GeorgeWNYC]

I'm still guessing here, but try these:
how many records are successfully exported, and how many left behind?

Are you exhausting the capacity of the EXCEL sheet?

is there a table created called tblTrueAR_ExportErrors?
What's in it?

 

[pvwdr]

No export errors ... there are only about 86 records.
After looking more closely, I am finding that in the Excel spreadsheet, on the records that are erroneous, the filds are shifted over to the left one...

Date Balance Age 0-30 30-60 60-90
1/1/03 1200.00 35 0 1200.00 0
2/1/03 600.00 4 600.00 0 0
1/28/03 550.00 7 550.00 0 0
750.00 24 750.00 0 0

This is what is happening ... I hope you can follow. I have Office XP SP2, which was a suggestion from someone else, so that is not the case ... I am stumped.

 

[GeorgeWNYC]

can you send me the table? My Hotmail address is the same as my tektips name. export the table to another mdb. I'd like to try it myself.
Zip the file plz

 

[pvted]

See Microsoft Knowledge Base Article - 294410

This doesn't seem to exactly describe your problem, but it is suspiciously similar. Their prescribed solution is to install Jet 4.0 Service Pack 6.

It does not appear that Office XP Service Pack 2 updates the Jet database engine.

Please give my regards to John Barleycorn.

 

[pvwdr]

Thank you, pvted, i will give your regards to mr. barleycorn and install the jet service pack