Hi, When I export from Access, the green error triangle appears in one of my columns. The column is formatted in the source spreadsheet as "number" with two decimals. When I look at the design view properties of the table that the source spreadsheet is linked to, I can see the Data Type is showing "TEXT" instead of number. If I try to change it to number, I get an warning telling me that the table is a linked table that can't be modified.
If I try to set the format in Access, it does not give me any options from the drop down when I click the "FORMAT" in the property sheet of design view.
How can I fix this?