Results 1 to 7 of 7

Thread: File type (A2k)

  1. #1
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    File type (A2k)

    Does anyone recognise the attached file structure and how can I transform it into a table ?
    I tried the import wizard which works great if the file is comma seperated.
    The file attached doesn't seem to be recognisable , fixed width, comma seperated etc.

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

    Re: File type (A2k)

    Dave, this file does not have a table structure. You will have to open it in code, read it line by line and parse each line. To be able to do that, you will have to determine for each line where bits of information begin and end and what they mean. The file itself contains no clue whatsoever.

  3. #3
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File type (A2k)

    Yes, I scratched my head a little also.

    I'm working on importing a txt or csv into one of our Windows based estimating systems, speaking to the company this afternoon, they say they have a document explaining their particular format.
    Hopefully they will send it to me tomorrow.

    Thanks anyway and all the best.

  4. #4
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File type (A2k)

    Hans

    Well, the company sent me the document detailing the structure of their fields and tables, 63 pages worth ??
    Difficult to decifer, fancy a challenge ??

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

    Re: File type (A2k)

    Not really...
    The file you attached earlier is not a table at all, it's more some kind of export file.

  6. #6
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File type (A2k)

    Thought not !!

    No doubt I'll be pulling my hair out then.
    You're right about the type, (Export), briefly flicking through the doc, most fields have to be padded with spaces etc.

    Let's see how it goes then.

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

    Re: File type (A2k)

    Good luck! Let us know how you get on, and don't hesitate to ask questions about specific problems.

Posting Permissions

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