View Full Version : Data Exchange Using SQL

  1. Connection to a remote pervasive databse
  2. Check for Existing Records Before doing Insert
  3. Connect to (Import) external data
  4. Correlated subquery that returns avg of top 10 readings by month.
  5. problem with connecting to database from a different excel file
  6. Change positive number to negative for some items in a field
  7. To organize the excel file and also get the ranges of values from database
  8. excel cells color based on sql result
  9. Transfering Data from Excel to IBM application
  10. XL and MS QUERY : How to declare variables ?
  11. importing data from SQL Server via data connection
  12. Convert date into int changes the value
  13. Excel 2010 SQL Server Connection
  14. Insert or update SQL table based on values in Excel
  15. Parameterization is required for this code
  16. How To Run A Stored Procedure with dynamic variables in EXCEL
  17. SQL converting mixed numeric/alphanumeric string to number
  18. Using SQL to search a text file for double quotes
  19. Date Range Parameter
  20. Problem with DDE/OPC- rslinx, retaining numerical data
  21. Problem with Acces database connection
  22. How to control formatting external data in 2007?
  23. relative path to excel file for query
  24. Cannot update the fields using ADODB from VBA
  25. Pass Oracle hints into a Power Query
  26. Change background of entry form
  27. The workbook is protected and can not be changed
  28. How to access every one cell in a table from a power query
  29. Passing a Parameter Value to a cell
  30. How to insert active rows from excel to SQL
  31. excel - sql query - parameters check for empty value
  32. VBA code - check if a record already exists in SQL table before inserting