• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

EXCEL VBA Data/Grid Control

uday1005

New Member
With EXCEL 2010, is there any control equivalent to "FlexGrid" OR "Data" control that I can use to manipulate data from SQL Server (Or Access) database?


Regards,
 
Hi, uday1005!

From the Programmer tab, Controls group, Insert button, ActiveX controls (bottom), More Controls icon (bottom right), then select Microsoft Office Data Source 11.0. You'll find ConnectionFile and ConnectionString properties.

Regards!
 
Back
Top