Truncated import

[Steve]

Unable to import text greater than 255 to a memo field
when using import text macro in access 97. This s not a
problem when using the get external data funtion or later
versions of access. Is their a solution ?

 

[Ken Snell]

You may need to use VBA code to open the text file and read it line by line,
parsing the lines into separate fields and then writing those values to the
fields in a recordset that you've opened on a table.