Dear group

When exporting data to a csv file in excel, how can I make sure all data values are quote wrapped (i.e. surround by double quotation marks), this includes empty fields, which will appear in the csv file as two quote characters toegether (e.g. "")

example csv file i wish to create.

"123456","03","20020404","06","Delay Reason","","","","","",""

I know in Access you can select Comma as the Delimiter, and " as the Text Qualifier during export options. However our client wishes to use Excel.

I was going to use ISBLANK function to replace blanks with "". & Use =CHAR(34)&'Data Entry Form'!B7&CHAR(34) to warp data items in quotes.

Is there a better way.

Thank you in advance