Excel Linked Table

A

A.M

Hi,

I have a linked Excel linked table with a column contains mixes number and
text data.
For text cell data i have #Num! in Access linked table.
The problem is Access takes that column as a Number (Long Intiger) column.
How can i make Access take that column as a text column?
I have had similar problem with mixed Date/Text columns.

Any help would be apprecited,
Ali
 
Top