Maintaining Data Types

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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#.
 
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


RS said:
I need to know how I can maintain the data types set a Access 97/2000
Click to expand...
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#.
 
Back
Top