Import Excel comments to field in Access

  • Thread starter Thread starter Pete
  • Start date Start date
P

Pete

I have an Excel spreadsheet with many cell comments. Is there a way to
easily import them into my Access table where I imported the rest of the
Excel data?
 
Easily? Not really. As far as I'm aware, you'd need to use VBA to
instantiate an instance of Excel, open the workbook in that instance, then
use Automation to search for each comment, determine to which record in the
database each one needs to be associated, then add each comment
appropriately by creating a recordset and adding it, or using SQL.
 
Back
Top