Is it possible to import Excel comments along with cell content?

[jayceejay]

I have several Excel cells that contain commented info. I would like to
import the Excel table from Access but I don't want to lose the comments.
Can anything be done?

 

[Douglas J. Steele]

There's nothing corresponding to Excel comments in Access.

I believe the only way to capture them would be to use Excel Automation, and
look cell-by-cell to see whether there's a comment. If there is, copy it
into a separate field in the table.

 

[jayceejay]

That confirms what I suspected. Many thanks for the confirmation.