Convert format error

[William Chong]

Dear Mdm/Sir,

I'm using Microsoft Access 2000 to write a program.

My problem is when I using acFormatRTF to convert my data,
the result is completed. But When I using acFormatXLS to
convert, then the data was not complete been converted to
Excel file.

May I know what go wrong and how to fix it ?

Thank You !

Reg,
William

 

[Van T. Dinh]

Depending on the Excel version you selected for export, there may be a limit
of 16 K or 64 K rows.

If you have more than 16 K Records in Access, check and m
ake sure you select the right Excel format to export to.

 

[William Chong]

Dear Van,

Actually, I'm using DoCmd.OutputTo to do the convert. But
it can't display out all the data in one cell at the Excel
sheet.

Hope you can understand what I mean here and thank you.

If my data is more than 16K, How I going to write to
export to the correct Excel version ?

Thank You !

Reg,
William

 

[Van T. Dinh]

I am not sure what you meant about the display...

However, check Access VB Help on the TransferSpreadsheet Method instead.