<div>
What information are you trying to pull of the chart?<br />

</div>


What information are you trying to pull of the chart?


<div>
Are all the charts alike?<br />

</div>


<div>
All the tables look essentially the same and the rows of the tables are identical (i.e. row 1 are the database fields). I guess what I'm asking is how do I connect via RDO, DAO, how do I access the rows/fields, and what the difference is between RDO and DAO.<br />
<br />
Thanks<br />

</div>


All the tables look essentially the same and the rows of the tables are identical (i.e. row 1 are the database fields). I guess what I'm asking is how do I connect via RDO, DAO, how do I access the rows/fields, and what the difference is between RDO and DAO.

Thanks


<div>
<div class="content wysiwyg-content">
I'm trying to write an application that will open a connection to several excel charts, open a recordset, and insert each record set into a SQL Server table (one per chart). &nbsp;Any ideas (and possibly code)?
</div>
</div>


I'm trying to write an application that will open a connection to several excel charts, open a recordset, and insert each record set into a SQL Server table (one per chart).  Any ideas (and possibly code)?

Automated Excel -&gt; SQL Server Data Transfer

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Automated Excel -&gt; SQL Server Data Transfer

Automated Excel -> SQL Server Data Transfer