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

  • Thread starter Thread starter jayceejay
  • Start date Start date
J

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?
 
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.
 
Back
Top