N
ngan
I noticed that during the link wizard, you don't have a chose of defining
field types for the excel columns. I have a Grade column that is mostly
numbers, but has a few text too. When linking the file, Access automatically
made that field number. So all of the records with text became #NUM!.
Can someone tell me how to make it so Access will know it's text? In the
original excel file, it's set to text.
I've tried to save the excel as htm, the grade column came over fine, but
now the phone number gets the error...because there are dashes and Access
assumes it's a number field.
field types for the excel columns. I have a Grade column that is mostly
numbers, but has a few text too. When linking the file, Access automatically
made that field number. So all of the records with text became #NUM!.
Can someone tell me how to make it so Access will know it's text? In the
original excel file, it's set to text.
I've tried to save the excel as htm, the grade column came over fine, but
now the phone number gets the error...because there are dashes and Access
assumes it's a number field.