B
Brian
I have linked a MS Excel worksheet as a table in my Access database. I have
a field that contains numbers and letters. I have formatted the cells in
Excel as text, but when it is linked in Access its data type is number, which
causes the fields with numbers and letters to be displayed as #Num! in my
Access table and form. I can't change the data type in Access. When I
attempt to I get the message "Microsoft Office Access can't save property
changes for linked tables." Is there any way to get around this issue?
Thanks for your help!
a field that contains numbers and letters. I have formatted the cells in
Excel as text, but when it is linked in Access its data type is number, which
causes the fields with numbers and letters to be displayed as #Num! in my
Access table and form. I can't change the data type in Access. When I
attempt to I get the message "Microsoft Office Access can't save property
changes for linked tables." Is there any way to get around this issue?
Thanks for your help!