Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jul 2005
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Import Specification Problem (Access 2002)

    I am having trouble with an import spec for a *.txt file.

    I have set up the spec to import the file using Fixed Width fields that I have set up. I will only import some of the fields that I create. I am then using code to import the data into a table. I get an error message which says "Text File specification field separator matches decimal separator or text delimiter" then the code bugs out without importing.

    My Code is as follows (standard stuff)

    DoCmd.TransferText acImportDelim, "01_Daily_Balances_Spec", "Tbl99_Balance_Upload", O:99_Downloads03_ACCOUNT_BALANCES.csv", False, ""

    Any ideas what is happening and how I need to fix it?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Import Specification Problem (Access 2002)

    A .csv file is a comma delimited file. Why are you treating it as a fixed width file?

Posting Permissions

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