USE SQL IN MANIPULATING DATA IN EXCEL
hELLO!
i would like to ask on how to use SQL to manipulate data stored in Excel
Workbooks. Do I have to set-up an ODBC Connection? if yes How? What would be
the best driver to use?
Another thing is how can I update, search and delete record (because the
program i'm doing right now can already add new record) in a worksheet using
userform.
I hope the MVP's here can help me and also to those who know about it.
Thank You in advanced!
|