Data Type Changes when linking excel

[rciolkosz]

Why on one laptop when you link an excel file as an access table the data
type follow correctly as currency, number, etc..

On another laptop the data type defaults back all the fields to text and
then the queries have a mismatched data type.

 

[John W. Vinson]

Why on one laptop when you link an excel file as an access table the data
type follow correctly as currency, number, etc..

On another laptop the data type defaults back all the fields to text and
then the queries have a mismatched data type.

Excel does not have "strong data types". Access must guess from the first few
(8??) lines of the spreadsheet what the desired datatype might be. It's
possible that the difference is not between the computers but instead between
the contents of the spreadsheets.

Text is the "lowest common denominator" - a given Excel cell might not be a
valid date or Float or Integer, but it's pretty sure to be valid Text. One
approach is to just link to the spreadsheet and then run an Append query into
a properly datatyped table, with possibly some conversion functions such as
CDate() or CDbl() thrown in.

 

[rciolkosz]

It appears to be working. I sorted the excel to show my data at the top of
the file and it is working. Great piece of information