Home > database >  ="'" & A1 & ""
="'" & A1 & ""

Time:09-28

how this is done!

CodePudding user response:

This is not a string concatenation,,

CodePudding user response:

Use excel splicing SQL, kao went to perform finally,

The original poster is the specific problem?

CodePudding user response:

Set the cell format for text in excle, direct copy and paste the cell to other places, the ends of the half-width symbols will have double quotes cover, find a editor to replace the quotes into an empty line, if there is no actual meaning in the data of double quotation marks,
  • Related