Importing from Excel is importing an invisible character

M

Michelle W.

I have a spreadsheet that has a column of department names. One of the
departments is Women's Studies.When I import the data into Access and try to
do a search in that column for Women's Studies, the search does not yield any
results. When I write a query that is looking for Women's Studies I do not
get any results. If I manually add a record to the table and type Women's
Studies in the department column, then I get that 1 record in searches and in
queries. The other existing records are ignored. There must be some invisible
character in that column but I don't know what it is or how to get rid of it.
We had the same problem with a department called "Physical Education -
Elective". The dash is causing the same problem.
 
M

Michelle W.

How come it is not importing the apostrophe or dash correctly? We have
departments with ampersands, slashes, and commas and those all worked
correctly.
 
K

Klatuu

The ' can be used in SQL in place of the "
This can cause problems (As you have experienced)
The - I am not sure. It could depend on the data type because the - is a
math operator.
 
Top