sql vba

  1. R

    please help me modify my vba code

    Dear All master, I want to connect with multi data source for dbf file with vba array code. what I want is the following: 1. Modify the connection string according to the dbase file provider 2. Can I connect with my multi DSN reference and become one sheet Data Source Name DefaultDir FILE NAME...
  2. R

    Access SQL query to Excel output

    Hi I am running sql which prompts the user to select the directory where they want to save the result. It worked when I had it as csv, but when I change it to be xlsx as below, I get the error "Excel cannot open the file 'filename.xlsx' because the file format for the file extension is not...
  3. H

    VBA and SQL: String in WHERE Clause throwing error

    Hello All, I'm using a connection to query an external database. Basically, I'm selecting a few columns and filtering them by a list of contracts. This list will always vary in length, so I'm iterating through a single column in a worksheet and then concatenating each row in a single string...
  4. G

    SQL VBA Query to pull data from Excel sheet in same format

    Hi Everyone, Have written code to pull data from one excel sheet to another using SQL VBA Query. The user interface has multiple filters (combo box) to filter data from the source excel sheet (serving as database). UI and database sheet are in same workbook.Everything thing is working fine...
  5. H

    Excel to SQL - using VBA to overwrite SQL database table

    Hello all, a quick question: How do we use VBA to overwrite SQL database table from excel? I have seen previous discussion here on how to insert data from excel to SQL using VBA...
  6. R

    SQL VBA problem

    Hello, I have a macro that doesnt work. The problem is at the 2nd date restriction that I have ((""CR-Ticket"".""Request Date""<={ ts '" & Format(Range("A1").Value, "yyyy-mm-dd 00:00:00") & "'}) Do you know, what I am doing wrong? With Selection.QueryTable<?xml:namespace prefix = o ns =...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top