Link File

  • Thread starter Thread starter Mike
  • Start date Start date
M

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
 
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")
 
Back
Top