Excel & Access

[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!

 

[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)

 

[Jamie Collins]

Is there a way to send certain cells of a MS Excel
spreadsheet into specific fields of a MS Access form?

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.

--