Linking Table in Access

[avenuw]

Hello,

I am linking an excel sheet in my access database and one of the columns contains numbers in format 22222 or 22GT67,etc. When I link the table, only fields with numbers (ie format 22222) get imported, the other fields display #NUM!. I tried to change the format of the column in excel to Text from Number and relink but I still get the same error.

Does anyone know what I can do to convert that column to text?

Thanks,
AV

 

[bubba100]

I assume that the first value in the field is 222222 or all numertic. Change it so that the first value is 222GT67.

Access looks at the first values in the field and expects all others in that field to be the same.

 

[avenuw]

The first value in the field is not all numeric, it is 222GT67.
I selected the entire column in excel and selected Format-->Cells-->Category changed to Text. And saved the excel file and relinked, but I still get the #NUM! error.

Thanks for your suggestion ( I wasnt aware thats what access does)but in this case its still not working.

Any help would be greatly appreciated
Thanks
AV

 

[avenuw]

I found the solution here. The last option is what worked for me.

Hope this helps someone else