docmd.transferText to Memo Fields

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
 
H

HSalim

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

HS
 

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

Similar Threads

Truncation of memo fields using DoCmd.TransferText acImportDelim, 1
Importing Excel Data Into MS Access Memo Field 2
Memo fields are truncated when including the textdelimiter char e. 2
unable to import from csv to memo field 1
Linked table column type changes from text to memo 1
Importing TXT file into Memo Field 1
problems importing a Paradox file into Access 2003 4
Import DBF files with MEMO fields 10

Top