Max File Length on Import Specs

[Stickarm]

Is there a maximum file length on importing an external file into access, I am having trouble defining fields after 500 charachters, is this a limit in access?

 

[NorthNone]

If there is a limit it is much higher than 500 characters. More information, please...is this a delimited text file, an Excel file, or ???? How many fields?

---------------------------------------
Remember, the customer may not always be right, but the customer is always the customer.

 

[luceze]

From the Access2002 help file:

Use a Text data type to store data such as names, addresses, and any numbers that do not require calculations, such as phone numbers, part numbers, or postal codes. A Text field can store up to 255 characters, but the default field size is 50 characters. The FieldSize property controls the maximum number of characters that can be entered in a Text field.

Use the Memo data type if you need to store more than 255 characters. A Memo field can store up to 65,536 characters. If you want to store formatted text or long documents, you should create an OLE Object field instead of a Memo field.

Both Text and Memo data types store only the characters entered in a field; space characters for unused positions in the field aren't stored.

You can sort or group on a Text field or a Memo field, but Access only uses the first 255 characters when you sort or group on a Memo field.

HTH,
Eric

 

[BNPMike]

You should be able to go to 2000 characters excluding memo and blob fields.