Close

Results 1 to 3 of 3
  1. #1
    DF VIP Member Fear345's Avatar
    Join Date
    May 2002
    Location
    entebbe
    Posts
    3,178
    Thanks
    180
    Thanked:        436
    Karma Level
    551

    Help Outlook csv file to excel

    Any excel wizards help me out please.
    I want to import a calender csv file into my excel worklog and import certain details i.e date, names, mileage, start and end time.
    I have attached my worklog and a csv file.[Only registered and activated users can see links. ]
    [Only registered and activated users can see links. ]
    [Only registered and activated users can see links. ]

  2. #2
    DF Probation Goldberg's Avatar
    Join Date
    Jun 2001
    Location
    Landaaaan!
    Posts
    14,466
    Thanks
    1,333
    Thanked:        1,558
    Karma Level
    1170

    Default Re: Outlook csv file to excel

    Maybe not the cleanest way of doing it, but I would do the following.

    * Open the .csv file in Excel. Should automagically place the data into columns.
    * Copy the page to a new sheet in your work log workbook.
    * On the 'Date' column press '=' then move to the worksheet you imported to the workbook and click on the first date.
    * Do this for the Start and Finish columns also.
    * Back to the main work log sheet, click on the first date. Then drag the small square in the bottom right corner down the full length of the column. What this will do is automatically increment the linked cell on the other sheet.
    * Repeat this for the Start/Finish columns and you are set.

    if you need help with it or even a little video (not of donkey dwarf porn!) then I can assist.
    We all make mistakes sometimes

  3. #3
    DF Jedi akimba's Avatar
    Join Date
    Jun 2006
    Location
    UK
    Posts
    3,017
    Thanks
    1,150
    Thanked:        836
    Karma Level
    336

    Default Re: Outlook csv file to excel

    I have done a simple import routine in your excel sheet, just change the yellow cell to the path of the file and hit import ;-)

    [Only registered and activated users can see links. ]

    You can change the code as needed in the VBA (hit Alt+F11) and change the importData routine

Similar Threads

  1. Outlook PST Data File - Move
    By Raptor in forum Windows 7 Tutorials
    Replies: 0
    Last Post: 11th April 2010, 04:50 AM
  2. Corrupt and excel file
    By Rob290482 in forum System Security
    Replies: 5
    Last Post: 22nd July 2009, 01:54 PM
  3. Anyway to recover this Excel file?
    By devs in forum PC Software
    Replies: 4
    Last Post: 28th May 2008, 02:28 PM
  4. Outlook and Excel
    By mjf5 in forum PC Software
    Replies: 2
    Last Post: 27th September 2006, 09:35 AM
  5. excel file shagged
    By Thrush in forum PC Software
    Replies: 2
    Last Post: 12th December 2003, 04:02 PM

Social Networking Bookmarks

Posting Permissions

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