M
Matt
When using the Import Spreadsheet Wizard, I would like to be able to change
the data type of one of the fields being imported. However, the Data Type
option is greyed out and inaccessible. It gives the data type of double by
default, even though I formatted the cells in the spreadsheet with text
formatting. Double would be fine for most of the records but there are a
couple that aren't in double format(they have text and numbers mixed), giving
me a data type conversion error when I import the spreadsheet. Any
suggestion on how to get around this or how to make the Data Type Option
available would be great. Thanks in advance. Matt
the data type of one of the fields being imported. However, the Data Type
option is greyed out and inaccessible. It gives the data type of double by
default, even though I formatted the cells in the spreadsheet with text
formatting. Double would be fine for most of the records but there are a
couple that aren't in double format(they have text and numbers mixed), giving
me a data type conversion error when I import the spreadsheet. Any
suggestion on how to get around this or how to make the Data Type Option
available would be great. Thanks in advance. Matt