Linking Text File : Error : "Record Too Large"

S

Susan Philip

Hi ,

I was trying to link a text file that has a record of almost 250 fields
of text data type and all these fields add upto a record of size 3000.
When I ran the Link Text Wizard I am getting an error saying the
"Record is too large".
I was wondering isn't that possible to link a text file with record
size 3000?
Can anyone help !!

Thanks
Susan
 
B

Brendan Reynolds

I haven't tested this - I don't have a suitable text file to use for
testing - but according to the 'Access Specifications' topic in the help
files ...

<quote>
Number of characters in a record (excluding Memo and OLE Object fields) when
the UnicodeCompression property of the fields is set to Yes: 4,000
</quote>

I would imagine that the JET database engine probably can't use Unicode
Compression with a linked text file, as the data is not actually being
stored by JET, so it may not be possible to link the file, but you may be
able to import it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Check length for each record for a delimited file 4
Importing Text File : Error "Field too Large" 4
A temp solution to "Record is too large" 2
#Error Message 1
Check if a date exists in a record 1
Adding a record from a text file 2
Error message: "record is too large" 1
Maximum record size and maximum number of records 3

Top