dfinke
ConvertFrom-ExcelToSqlInsert - ignore or change quoted character
I am trying to use ConvertFrom-ExcelToSqlInsert. It is a very useful tool, but my current use case is I have parameters and inline select statements for the data. All columns are being wrapped in a ''. Is there a way to not include any and only include them if I want. For instance if I pass GETDATE() as a value in the excel file it is being changes to 'GETDATE()' which is a string and not executing the formula in the sql statement. I looked at the docs but did not a see a way to remove the quotes. Also how does this handle numbers/booleans? They seem to be quoted to which I don't like the idea of converting the number to string on insert. I would like to request there either be a value to change the quote to any character or a way to tell it to use the data as raw so in the excel file I would include the quotes. I think my work around for now is to add double quotes and do a remove/replace. Sorry I know this is nitpicky, but wanted to ask if I was just missing something or not.
