linking txt or xls files

[abolin]

I linked a table but see #num! in a column, what does that mean?

 

[Fabio Fierro]

I linked a table but see #num! in a column, what does that mean?

 

[Ken Snell MVP]

See this article:

Avoid DataType Mismatch Errors when Importing Data from an EXCEL File or
when Linking to an EXCEL File
http://www.accessmvp.com/KDSnell/EXCEL_Import.htm#DataTypeErr