- Connection to a remote pervasive databse
- Check for Existing Records Before doing Insert
- Connect to (Import) external data
- Correlated subquery that returns avg of top 10 readings by month.
- problem with connecting to database from a different excel file
- Change positive number to negative for some items in a field
- To organize the excel file and also get the ranges of values from database
- excel cells color based on sql result
- Transfering Data from Excel to IBM application
- XL and MS QUERY : How to declare variables ?
- importing data from SQL Server via data connection