Import help of a 2000 character record

[leah1]

Caan I import a file which contains records which are 2000 characters long from a text file into MS Access?

 

[PaulF]

yes, if they represent different "fields", then you can design an import specification to bring them into an Access table split into the corrrect fields . If all 2000 characters belong to one field, then you can still create an import specification to bring the data into a table with one Memo Field type. See TransferText in the Access Help File.

PaulF

 

[leah1]

The import is not working --I am getting a message "record is too large" The import spec I have developed is for exactly 2000 characters.

 

[PaulF]

This is from the Access 97 Help File for
Additional size limitations on a replicated database

The Microsoft Jet database engine allows a maximum of 2048 bytes (not counting Memo or OLE Object fields) in a record. Replication uses a minimum of 54 bytes to store unique identifiers, indexes, and information about changes to the record. If the record contains either Memo or OLE Object fields, replication uses an additional 4 bytes for each of those fields. The total number of bytes available in a record in a replicated table can be calculated as follows:

2048 bytes
- 54 bytes for replication overhead
- (4 bytes * the number of Memo fields)
- (4 bytes * the number of OLE Object fields)
= the maximum number of bytes available




Notice it states 2048, so I'm not sure what is happening.
Can you reduce the size of any of the fields that might have additional spaces in them, or skip one field from being imported? Did you uncheck the box in the specification that determines whether or not Access attaches a AutoNumber ID Field to your table?

PaulF