Macro button to export excel spreadsheet as SQL file

Hi everyone,
I'm new here and I would love to learn from everyone the secrets of excel.
I have an assignment from my job which is to create a macro button to generate a SQL file from a spreadsheet.
The workbook contains different s sheets and each one contains tables to be exported.

I want help to create this button which generates a SQL file from a particular sheet, any I chose (ex: export the values from the Location_sheet - all the data at once, without having to write it down the rows but the columns only, like SITEID, LOCATION, DESCRIPTION).

I hope you guys can understand me

Please support.

I think it's pretty clear what you're wanting, but we could use a sample file, we also need to know what database it is

Buran
I will try to upload my file here,
But, in case I want to upload a table information to Oracle SQL from excel
I have column name and the values. What should I do?
it would be possible to create a button to extract the file as SQL? or should I just write a insert statement with columns name and mentioning the values? Because I have a table with 5 columns and thousands of rows.

Please support

tbh it's not really worth creating a button, just create a formula, drag it down and copy and paste it. That's what I do

Numbers aren't usually strings so you wouldn't enclose them, but it depends on the datatype of the field - so noone can answer you

@buran, what's wrong with copy and paste?

You simply put the formula in each, row, drag down and copy and paste the column into your SQL editor and execute it. VBA is a bit overkill here

It's typically painful to do with server based databases since typically the user and the database will not both have access to the same files. So to do it as csv, whilst possible is usually painful and a pain.

Copying and pasting is a doddle though, the OP has access to a SQL editor presumably since he has written the sql to go in it and is doing something with the SQL after creating it.

Even if it's not a one time task, it's still easy, especially with tables that copy the formula down to the bottom of the data

Dears, I've decided to use the string:
problem: I have to many characters, so I have to use CONCATENATE but its not working, any suggestion?

This is the code

= CONCATENATE ("insert into ORACLE.LOCATION (FIELDNAME, SITEID, LOCATION, DESCRIPTION, (M)TYPE, PARENT, FAILURECODE DESCRIPTION, FAILURECODE, SAFETY CRITICAL (FL010), TAG CRITICALITY (FL08), EX REGISTER (FL02), ANGILLEVEL, GLACCOUNT, ANGENGSYSID, SYSTEMID, (M)STATUS, ANGDRAWNUMBER, GRID REF (FL09), PHYSICAL AREA (FL03), MAINTENANCE JUSTIFICATION, ADOPTED STRATEGY (L02)) CONCATENATE ('" & B4 & "','"& C4 & "','" & D4 & "','" & E4 & "','" & F4& "','"& G4 & "','" & H4& "','" & I4 & "', '" & J4 &"', '" & K4 &"', '" & L4 & "', '" & M4 & "', '" & N4& "', '" & O4 & "' '" & P4 & "','" & Q4 & "','" & R4 & "', '" & S4 & "','" & T4 & "','" & U4 & "','" & V4 & "')")

using INSERT INTO
its says: Text values in formulas are limited to 255 characters. to create text values longer than 255 characters in a formula, use the CONCATENATE function or the concatenation operator (&)

So I used the CONCATENATE but is gives me the same error

I'ts working!
Thanks so much for you support. Thanks a lot. Any more doubt I will reach you.