Import Excel comments to field in Access

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?
 
D

Douglas J. Steele

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Import data from Access to Excel containing VB code 3
Import to many to many table 7
Error while import Excel file to Access 6
Excel Excel 2007 Copy Comments to Cells 0
How can I import an unstandard Excel worksheet into Access 2007? 3
Import Excel Comments to an Access Database 3
Data Type Issue in Linked Excel Table 7

Top