I'm linking an Excel Table to Access, but when I link it Access doesn't read some of the fields because Access pre-assigns the data type based on the first couple of records. The fields I have are Numbers and Text combined and Access declares them as TEXT, so when the fields are all #'s Access shows them as "#Num!." Also I have tried to import the sheet but again Access dictates the fields so it'll declare some columns has NUMBER so the fields with text have an error. How can I solve both problems?