View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chinx21 Chinx21 is offline
external usenet poster
 
Posts: 25
Default 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!