ExcelBanter - Can Excel write to an Access DB?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Can Excel write to an Access DB? (https://www.excelbanter.com/excel-programming/272958-can-excel-write-access-db.html)

Mike[_36_]

Can Excel write to an Access DB?

Is there a way to use Excel to read from and write to MS Access databases?

Mike

Ron de Bruin

Can Excel write to an Access DB?

Hi Mike

See http://www.erlandsendata.no/english/vba/adodao/
For example code

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl

"Mike" wrote in message ...
Is there a way to use Excel to read from and write to MS Access databases?

Mike

All times are GMT +1. The time now is 01:31 PM.