Excel cell comments

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

I have never tried that, but I would guess that you'd have to program that in Access. I don't think the import functions in Access acknowledge/read Excel comments.

TF

" wrote:

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

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
have to program that in Access. I don't think the import
functions in Access acknowledge/read Excel comments.

TF

" wrote:

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

.

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
'=======================

wrote:
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.)


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html