Excel Comments

[EasyAl]

When I import an Excel file to Access, the comments in the cell do not appear to be available. How can I transfer the comments into Access such that they can be associated with the imported cell and displayed?

 

[GVaught]

Excel Comments can't be imported to Access. Do not mistake in thinking
Access will operate like Excel. You are talking apples and oranges. If you
want the comments from Excel, you will have to create a field and manually
retype them.

When I import an Excel file to Access, the comments in the cell do not

appear to be available. How can I transfer the comments into Access such
that they can be associated with the imported cell and displayed?

 

[EasyAl]

Thanks for the info; I was hoping it wasn't true

 

[John Nurick]

It's not quite that bad. When I have to do this I write an Excel macro
that scans the Excel sheet looking for comments, extracts the text and
places it in a new column which can be imported as a memo field.

 

[jamieuk]

Excel Comments can't be imported to Access. Do not mistake in thinking
Access will operate like Excel. You are talking apples and oranges. If you
want the comments from Excel, you will have to create a field and manually
retype them.

I hope you don't mind me saying but that's the worst bit of advice
I've heard in a long while.

We are talking VBA, so that's a whole barrel of apples and no oranges.
Using Excel VBA I can access a cell's Comment e.g.

Sheet1.Range("A1").Comment.Text

If I can get at it with VBA then I can export it to MS Access or
import it from MS Access.

'You will have to retype them'? You should be ashamed.