excel-vba-mysql

  1. T

    I am getting this error run-time error '3001': Arguments are of the wrong type, are out of acceptable range, or are in conflict with o

    i have code link this to Update data in mysql through excel Please help me out i have made some changes in mysql db I HAVE TAKEN IN MYSQL DB(Column) WMS_ID AS VARCHAR(45) AND A PRIMARY KEY example:This is my table whos Column look like this i am trying to make this column unique...
  2. U

    it shows update succesfully but it is not update in the database please let me know

    i wanted to update excelsheet dynamically how can i do using excelsheet vba to mysql PLEASE HELP ME OUT I AM STUCK HERE i hve downloaded data from batchname(tblprod_agr_007) in excelsheet from mysql database its starts with column name WDS_id what ever i edit in that data(excelsheet) it...
  3. U

    i wanted to update excelsheet dynamically how can i do using excelsheet vba to mysql

    i wanted to update excelsheet dynamically how can i do using excelsheet vba to mysql PLEASE HELP ME OUT I AM STUCK HERE i hve downloaded data from batchname(tblprod_agr_007) in excelsheet from mysql database its starts with column name WDS_id what ever i edit in that data(excelsheet) it...
  4. U

    Run time error 9: subscript out of range please help me out

    ReDim array_values(aheight) Do Until count = aheight 'repopulate the first cell If IsNumeric(array_fields(count_2 + 1)) Then strQuote = vbNullString Else strQuote = "'" End If cell = strQuote & esc(array_fields(count_2)) & strQuote 'Populate the cell...

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