Truncated import

  • Thread starter Thread starter Steve
  • Start date Start date
S

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 ?
 
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.
 
Back
Top