PDA

View Full Version : bind ListObject to Recordset?



dlh
04-17-2009, 06:47 PM
I'm trying to build a tool that will enable view/edit of a database via Excel. Is there a way of "binding" a ListObject or a Range to an ADODB.Recordset? I've found various hints that it's possible but only using Microsoft Visual Studio Tools for Office (VSTO). All I've got is VBA. Is anyone versed in this and can tell me exactly what pieces are required? Is the full $800 development package the only answer?

Dr.K
04-18-2009, 06:15 AM
I've built tons of database tools with Excel front ends... Yes, you can do it ALL with ADO. ADO is amazing and is free.

However, I don't understand what you are tyring to do... Are you SELECTing data from the DB to populate a worksheet/form/form control, or are you trying to INSERT or UPDATE data in the DB?

Explain what you need, and I can post some code.

Also, how much SQL do you know?