Import Excel Comments to an Access Database

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

Guest

Is there a way to import Excel "comments" to an Access database?

A client is using Microsoft Office 2003, and wants to convert their Excel
data to Access. Many of the records in Excel have important comments they
need to include in the Access database.

Any suggestions will be helpful.
 
Only way I know would be to use Automation to read the EXCEL file and the
comments attached to the cells, then to write the comments into a field in a
table.

If the EXCEl spreadsheet contains a "primary key" value in each row, you
could import the data separately first into a table, then use Automation to
read the comments and write them to the table records via an append query or
a recordset in VBA code. Otherwise, you can use Automation to read/write the
regular data and the comments at the same time.
 
use Excel Automation to extract the comment property from each range.
The following is from the Excel VBA Help.
Comment Property
See AlsoApplies ToExampleSpecifics
Comment property as it applies to the Range object.

Returns a Comment object that represents the comment associated with the
cell in the upper-left corner of the range. Read-only Comment object.

expression.Comment

expression Required. An expression that returns a Range object.
 
I too have the need to export comments to an access database but I am not so
acquainted with Excel and am wondering where this Excel Automation function
can be located in the program. I am using a swedish version of excel but
anyway, I think I have located (under tools, add-on meny) a list of available
automationservers. Am i even close ?

/Angela


"Dean" skrev:
 
Back
Top