How to Import Data Inside the Text Box in Excel into Access?

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

Guest

Is there a way to import data from a text box in Excel into Access? I need to
find an automated way to do this because I am doing this task for a large
number of spreadsheets.

Any help would be very appreciated!!
 
You'll need to write VBA code that opens the workbook, finds the textbox
(IIRC this is done via the worksheet's Shapes collection) and gets the
text (IIRC from its TextFrame).

It's not simple, especially if there are multiple shapes on the
worksheet and you need to relate text from each textbox to values in
nearby cells. You'll need a good understanding of VBA and the Excel
object model.
 
Back
Top