sqlstring

  1. M

    Create user in Oracle with VBA from cell value

    Hello, Is it possible to create user in Oracle with VBA from cell value? I have defined connections etc., loop to check cells for values and for each cell with some value i need to run create user command in oracle Below lines are not working Dim SqlString As String SqlString = "create user '"...
  2. M

    SQL query in VBA, code maxing out at 32,767 characters and QueryTableBuilder throwing up a 1004

    Hi all, So I have a chunk of SQL code in a macro that updates a table from a database. This code includes a function that takes a bunch of data from a sheet down a column and splits it up into quotes & comma separated values to use on a 'WHERE' statement. With a small amount of data down this...

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