Link File

[Mike]

I am trying to like a text file into an access database; however, it comes
back saying that 'one or more rows of data in your file contain too many
characters to import. The maximum characters per row is 65000.'

Is there a way around this?

Thanks in advance,
Mike

 

[Wayne-I-M]

Format the field that you are importing into as a Memo field not a text field.

You can get the full specs for access by opening Help and typeing in
"Specifications.
Memo fields will take up to 1Gb of data (thats a "lot")

 

[Mike]

I did; however the file is still not linking correctly.