Excel & Access
 

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!

Excel & Access
 

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)

"Michelle" wrote in message
...
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!

Excel & Access
 

"Michelle" ...

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.

--