T
Tom
I save a spreadsheet into a tab-delimited text file for later import into an
Access database.
One column contains text strings in which "comma values" can be found.
Once save to the text file, those records that have commas in the Excel
cells now contain double quotes (".....") at the beginning and end of the
text string.
As a result, during the data import into Access (and later comparison), the
records are considered new and add records to tables.
During testing procedures, I realized that replacing the comma with a
semicolon would not add the double quotes when saving to the text file (but
a semicolon simply doesn't "look right" in the middle of a sentence string).
So, my questions are:
- Why does the "error" (double quotes) happen with a comma, but not w/ a
semicolon?
- Is there a way around this (I prefer to use the comma instead of the
semicolon)? The cell data type is "General" and "Text".
Thanks,
Tom
I am saving a spreadsheet
Access database.
One column contains text strings in which "comma values" can be found.
Once save to the text file, those records that have commas in the Excel
cells now contain double quotes (".....") at the beginning and end of the
text string.
As a result, during the data import into Access (and later comparison), the
records are considered new and add records to tables.
During testing procedures, I realized that replacing the comma with a
semicolon would not add the double quotes when saving to the text file (but
a semicolon simply doesn't "look right" in the middle of a sentence string).
So, my questions are:
- Why does the "error" (double quotes) happen with a comma, but not w/ a
semicolon?
- Is there a way around this (I prefer to use the comma instead of the
semicolon)? The cell data type is "General" and "Text".
Thanks,
Tom
I am saving a spreadsheet