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

    Transfering Data Into Corresponding Fields (Excel 2000)

    hi,
    hope to get some helps. i will import a deliminated text files into a worksheet. The data from the txt files
    will be in the layout base on the following tables:
    currency_code 4 char,
    currency_year_month DATE,
    currency_exchange_rate FLOAT.

    thus, sample data would be :
    USD,JAN-2001,1.83
    USD,FEB-2001,1.79
    USD,JAN-2002,1.80
    USD,FEB-2002,1.80
    USD,JAN-2003,1.79
    USD,FEB-2003,1.79

    Once i imported the text files into the worksheet, i need the data to be placing
    into the respective columns eg:
    <pre>currency mth year exchange rate mth year exchange rate ......
    USD JAN-2001 1.83 FEB-2001 1.79
    USD JAN-2002 1.80 FEB-2002 1.80
    USD JAN-2003 1.79 FEB-2003 1.79
    </pre>


    I have attached a sample excel table. how can i do this tasks...
    thanks in advance..

    **edited by Rory:
    I have copied the attachment here from the cross-posting in VB/VBA/.Net
    **
    Attached Files Attached Files

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Transfering Data Into Corresponding Fields (Excel 2000)

    Have you tried the text import wizard in Excel? It launches automatically when you open a text file.

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

Posting Permissions

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