Excel & Access

M

Michelle

Is there a way to send certain cells of a MS Excel
spreadsheet into specific fields of a MS Access form? I
appreciate any help you can provide! Thank you!
 
B

Bob Phillips

I would use ADO to do it. Search Google with 'update access ado' as the
keywords, you'll get some examples there.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
J

Jamie Collins

Michelle said:
Is there a way to send certain cells of a MS Excel
spreadsheet into specific fields of a MS Access form?
Click to expand...

Do it the other way round i.e. get your MS Access form to fetch the
cells' values. You could use ADO to query the closed workbook.

Jamie.

--
 
Top