I am trying to import data from a csv. the base import works fine but I want to add data in a couple of fields so I am trying to create a query that will join the sql server table and the access table. I join it on two fields. a car number and car initials. I am able to join on the car number but it wont let me join on the initial, which is just a text field.
Does anyone know why this is happening.
One interesting thing I am seeing is that in the query if I click in the Initial field the data looks blank. If I click out it shows the data. This doesn't happen on any of the other fields so It must be related to the issue somehow.