Excel Comments (Access 2002)

Topic

New Reply

I have an excel spreadsheet that I need to import. It has comments in various cells. Is there a way to import the spreadsheet into a table in Access and include the comments?

Reply | Quote

Replies

Access doesn’t have cell comments, so you’d have to create extra fields to store the comments in, or a separate table linked to the imported table. You’d need to use code to loop through the cells of the table in Excel to retrieve the comments, and store them in the extra fields or table.

Reply | Quote

I had the feeling I would have to do that. Thanks for the quick response!

Reply | Quote