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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 inserts quotes when saving SS as text and comma is pres
You can save yourself a step or two by starting in Access and doing the
following: Click File in the menu, select Import Data, Get External Data In the Link dialog box, change the files of type to Excel and then locate and select the Excel file and click OK Select the worksheet you want to use, click Next and then inform Access as to whether or not the first row contains the field headings. When you click Finish the data is mapped to the MDB file. You can either use the data as is or you can run an Append query using the Excel file as your data source to populate an existing table. -- Kevin Backmann "mklapp" wrote: 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? |
Reply |
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) |