Importing from Excel is importing an invisible character

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
How come it is not importing the apostrophe or dash correctly? We have
departments with ampersands, slashes, and commas and those all worked
correctly.
 
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.
 
Back
Top