excel for mac escape single quotes in csv

String fileEntries = Directory.GetFiles(SourceDirectory, '*' + FileExtension) String SourceDirectory = SourceFolderPath Here is the C# script code I'm working with: try In the code below I tried to insert the following before the FIRST line within the WHILE loop below: Operator) in query expression ''SAM'S/COSTCO - RETAIL/CONSUMAB')'.Īt .ExecuteCommandTextErrorHandling(OleDbHResult hr)Īt .ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)Īt .ExecuteCommandText(Object& executeResult)Īt .ExecuteCommand(CommandBehavior behavior, Object& executeResult)Īt .ExecuteReaderInternal(CommandBehavior behavior, String method)Īt .ExecuteNonQuery()Īt ST_() I am getting this error when I execute the code: (0x80040E14): Syntax error (missing CSV file to remove the single quote and run the C# code again then the issue is resolved but the manager for this excel file wants it there and I'd like to remedy the code in order to provide that.

If I do a REPLACE function within the SQL code that creates the. Just a point of clarification, I am NOT INSERTING RECORDS into a DB but into an EXCEL file.Īny help/direction would be appreciated.

XLS file because the Excel Connection Manager does not work well but having issues when trying to accomplish this via the C# script below. In an SSIS package, I’m trying to write out the contents of a.

Excel for mac escape single quotes in csv