I am trying to generate .sql scripts to drive a DTS package, I am using Excel as the hub as certain elements within the script change on a weekly basis. So I am the stage where I want to export my worksheet into .txt/.sql format. However, when I use the FileFormat:=xlText export function, the exported text file includes inverted commas around code which has commas.
Is there a way I can export an excel worksheet into a .txt/.sql compatible format which includes commas which doesn't include inverted commas?
Is there a way I can export an excel worksheet into a .txt/.sql compatible format which includes commas which doesn't include inverted commas?