| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 inserts quotes when saving SS as text and comma is pres
Hello,
I have a spreadsheet that needs to be imported into an Access database. I am saving the Excel file as text (spreadsheets import so poorly). Problem is, one of the columns occasionally has a comma or period in the cells. When this is saved as text (tab delimited) Excel decides it must apply quotes to the data. This is extremely undesirable and certainly not needed. The file is tab delimited, so commas do not need to be sequestered. How can I 'save as' tab delimited text from excel without excel trashing my process by trying to help in ways it is not asked to help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| comma delimited & surrounded by quotes | Excel Discussion (Misc queries) | |||
| Why Saving a file to a CSV, Excel does not put text into Quotes? | Excel Discussion (Misc queries) | |||
| Excel 2003 - Save As function inserts "Copy of" | Excel Discussion (Misc queries) | |||
| Saving as Text (tab delimited) surrounds text with "quotes" | Excel Discussion (Misc queries) | |||
| saving an excel file as text without text in quotes | Excel Discussion (Misc queries) | |||
Threaded Mode
