Excel Comments

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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


EasyAl said:
When I import an Excel file to Access, the comments in the cell do not
Click to expand...
appear to be available. How can I transfer the comments into Access such
that they can be associated with the imported cell and displayed?
 
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.
 
GVaught said:
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.
Click to expand...

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