Maintaining Data Types

[RS]

I need to know how I can maintain the data types set a Access 97/2000 table linked from Excel, certain fields remain as text but some fields are defaulting to number although they contain alpha characters. The entire field is set as text, those fields with no data return a 0 value (in Access) while those fields that contain text (alpha and numeric) return the error message NUM#.

 

[Michel Walsh]

Hi,


Make sure rows with alphanumerical data appears in the first ones, among the
first five rows if possible. Only the first rows are scanned to determine
the nature of the data for each column when the importation occur.


Hoping it may help,
Vanderghast, Access MVP

I need to know how I can maintain the data types set a Access 97/2000

table linked from Excel, certain fields remain as text but some fields are
defaulting to number although they contain alpha characters. The entire
field is set as text, those fields with no data return a 0 value (in Access)
while those fields that contain text (alpha and numeric) return the error
message NUM#.