docmd.transferText to Memo Fields

  • Thread starter Thread starter HSalim
  • Start date Start date
H

HSalim

Hi,
I have a text file that has one text column that is 999 chars wide (As per
the spec, although currently the column is only about 100 chars wide)
I am importing the data into a table that uses a Memo datatype for this
column
I can import the data using the import wizard, and using an import
specification
However, if I do the same thing in code,
the memo field is empty.

Any idea what could be wrong?

Regards
HS
 
Nevermind, I was using a Fixed-width specification and the
docmd.transfertext had acimportDelim
as the textfile type, which caused the problem.

HS
 
Back
Top