Convert format error

  • Thread starter Thread starter William Chong
  • Start date Start date
W

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
 
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.
 
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
 
I am not sure what you meant about the display...

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