Delimited text import errors

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
 
J

Joe Fallon

If you zip it and e-mail it to me I will review it this weekend.
(Remove the nospam from my address.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top