Can one convert an Access datasheet field to an Excel comment?

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

Guest

Can one convert an Access field to an Excel comment? I have a database where
each record has several phone numbers. I have to periodically convert this
to Excel. I would like to put all the phone number fields in a comment or,
as an alternative, in one cell, rather than have several columns of phone
numbers. Any thoughts?

Thanks.
 
Combine the phone numbers together in a query. Then export the query to
Excel. The field in the query would look something like:

Phones: "Home: " & [HomePhoneField] & " Fax: " & [FaxField]
 
Back
Top