Import Excel symbol not recognize

[tomtom1126]

Dear all,

I did the excel file import to access table.
one of the field contain the symbol like "/", import is ok but when I use query to filter in this field and found, system can not recognize it.

when I clear it and retype on it, system can be recognize it. so what is
the problem on it?

thanks all big hand to give me a hand.

Regards
Tom

 

[llkhoutx]

Note that the data type of imported columns is determined by the data in the first row imported. I suspect that your column is of an improper data type.

 

[tomtom1126]

Thanks llkhoutx,

You are right, the excel file problem. I change another file to import is normal.

Thanks for your help.

Tom