Thursday, May 26, 2011

Export Excel CSVs with Double Quotes

visit... http://www.markinns.com/articles/full/export_excel_csvs_with_double_quotes

Very useful to transfer data from Excel to CSV. without this VBA code you have to replace all , with space

Use this with CSV using LOAD DATA and use Local LOCAL keyword