Delimited text import errors

  • Thread starter Thread starter Ray
  • Start date Start date
R

Ray

If I manually import delimited text files into my
database I have no error but if I use a VB DoCmd it
truncates memo fields in the same 18 rows. There is no
pattern to the rows or the sizes of the truncated memo
fields. All the memo fields affected are in the same
column, and even if I swop data around from the affected
rows, it still truncates the same rows, even with
different data in them.

The database contains 843 rows of records, has 26 columns
and is 305Kb in size, is there any way around the problem
as it is neccesary to use a macro to automate the process?

Any help would be greatly appreciated.
Thanks
Ray
 
If you zip it and e-mail it to me I will review it this weekend.
(Remove the nospam from my address.)
 
Back
Top