Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel to csv export
Hi
I am trying to export my spreadsheet as a csv file. I would like to have double quotes for each cell content exported. This csv file is used to load a table in sqlserver. Currently there is no option to do this. I would like to do this because if my cell contains a comma then the export will fail. Or is there another way to do this? Please inform. Thanks Babu |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel to csv export
I would think writing a macro to export the data exactly the way you want it
would be the way to go: Some samples: Earl Kiosterud's Text Write program: www.smokeylake.com/excel (or directly: http://www.smokeylake.com/excel/text_write_program.htm) Chip Pearson's: http://www.cpearson.com/excel/imptext.htm J.E. McGimpsey's: http://www.mcgimpsey.com/excel/textfiles.html Earl's program has a supports lots of different options. You may want to see if that works for you right out of the box. If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Bob wrote: Hi I am trying to export my spreadsheet as a csv file. I would like to have double quotes for each cell content exported. This csv file is used to load a table in sqlserver. Currently there is no option to do this. I would like to do this because if my cell contains a comma then the export will fail. Or is there another way to do this? Please inform. Thanks Babu -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Export to Microsoft Excel from IE | Excel Discussion (Misc queries) | |||
excel chart export error runtime 1004 | Charts and Charting in Excel | |||
Export excel file to semicolon delimited text file | Excel Discussion (Misc queries) | |||
export excel to Front Page | Excel Discussion (Misc queries) |