Here are some examples of how to use SQL within the Excel environment. In some cases you will also need MsAccess on your PC.
SQL in Excel
Excel to MsAccess
UPDATE and COUNT using SQL.REQUEST
INSERT records into a closed workbook using SQL
Please write to us
Last edited: 01-Mar-2011 20:50