Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    10

    Unanswered: urgent help with importing!!!!!!!!!!

    I want to import a txt file to access, for that I have used this action:
    DoCmd.TransferText acImportDelim, "Mendag Import Specification", "importMixing", sFic
    But when I execute this access give me an error, if I press yes to Do you want to proceed anyway? the system put the data in the table but put everything in the first field. I don't know what is the problem because in the specification are definited the widths of the fields and it's ok.
    May you help me please?
    Thank you

  2. #2
    Join Date
    Jul 2004
    Location
    Southampton, UK
    Posts
    368
    Parnas
    Check what delimiter you are using in your import spec e.g. tab or comma etc. Then check your import file to ensure it contains the required delimiter after each item of data.
    HTH
    Chris

Posting Permissions

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