Maintaining Data Types

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RS - 16 Dec 2003 19:51 GMT

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

Reply to this Message

Michel Walsh - 16 Dec 2003 21:56 GMT

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

Reply to this Message