Excel cell comments

G

Guest

I have a column of cells that each have a comment attached
to the cell. Is there a way to take those comments, and
keep them attached to the record of data when creating a
table in Access?
Pieces of record:
Name Last Name Height(comments here like 5'3", 5'4",
etc.)
 
G

Guest

Thanks,
You are right when you say Access doesn't read the Excel
comments. I think a macro might be the way to go. GW
-----Original Message-----
I have never tried that, but I would guess that you'd
Click to expand...
have to program that in Access. I don't think the import
functions in Access acknowledge/read Excel comments.
 
D

Debra Dalgleish

You could use a macro to copy the comment text to another column, and
include that field in the export. For example, the following code
places the comment text in column 5:

'========================
Sub CommentsToCell()
Dim cmt As Comment
For Each cmt In ActiveSheet.Comments
Cells(cmt.Parent.Row, 5).Value = cmt.text
Next
End Sub
'=======================
 
Top