Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2005
    Posts
    113

    Unanswered: Problems with textimport

    I have imported text through
    DoCmd.TransferText acImportDelimited, "SpecName", "tableName",_
    strInputFileName

    I have a field of the type multiline text. If the user press Enter in the textfield I get and error with the import of the text. The fields imports in the wrong order.

    How should I bypass this? Shall I open the textfile and search after char(10) & char (13) and remove these characters? Is there an easier method?

    //Julita

  2. #2
    Join Date
    Feb 2007
    Posts
    348
    so your incoming text looks like:
    Text|Text2|Mulitline Text|Text4
    TextA|Text2A|Multiline
    TextA|Text4A
    TextB|Text2B|Multiline TextB|Text4B

    ?

  3. #3
    Join Date
    Nov 2005
    Posts
    113
    My text looks like

    Text1 as char 255 <TAB> Text2 as char 255 <TAB> Text3 multiline <TAB> Text4 as char 255.

    My text is tabdelimeted.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •