I am using Excel 2007,

I have an Excel file with comments associated with certain cells. I also
have an Access database. Does anyone know if it is possible to somehow get
the comments in my Excel file exported or somehow brought into an Access
table?

Yes that is possible but it requires an good understanding of VBA. Oddly
enough I just finished doing the exact same thing sending the comments into
DB2. Here is a run down of how it is done.

Traverse through all of the cells with comments creating (on a seperate
sheet) a list of those comments including any necessary other info such as
the Author and ???. When you do this you will want to strip out the Line
Feeds that tend to get included in the comments.

Now you need an understading of ADODB recordsets. Connect to your data base
and open up your table. Add a new recordset and for each field in the
recordset add the corresponding comment value. Keep adding more recordsets
until all of the comments are done. Now just update the recordset and you are
done... I have some code but it is specific to my application so it will not
necessarily translate easily. That being said it is yours if you want it...
--
HTH...

Jim Thomlinson


"Woody" wrote:

I am using Excel 2007,

I have an Excel file with comments associated with certain cells. I also
have an Access database. Does anyone know if it is possible to somehow get
the comments in my Excel file exported or somehow brought into an Access
table?

Hi,

Just a suggestion - Might give him the code snippet since you just coded this?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Jim Thomlinson" wrote:

Yes that is possible but it requires an good understanding of VBA. Oddly
enough I just finished doing the exact same thing sending the comments into
DB2. Here is a run down of how it is done.

Traverse through all of the cells with comments creating (on a seperate
sheet) a list of those comments including any necessary other info such as
the Author and ???. When you do this you will want to strip out the Line
Feeds that tend to get included in the comments.

Now you need an understading of ADODB recordsets. Connect to your data base
and open up your table. Add a new recordset and for each field in the
recordset add the corresponding comment value. Keep adding more recordsets
until all of the comments are done. Now just update the recordset and you are
done... I have some code but it is specific to my application so it will not
necessarily translate easily. That being said it is yours if you want it...
--
HTH...

Jim Thomlinson


"Woody" wrote:

I am using Excel 2007,

I have an Excel file with comments associated with certain cells. I also
have an Access database. Does anyone know if it is possible to somehow get
the comments in my Excel file exported or somehow brought into an Access
table?