Close

Results 1 to 3 of 3
  1. #1
    DF VIP Member Fear345's Avatar
    Join Date
    May 2002
    Location
    entebbe
    Posts
    3,153
    Thanks
    174
    Thanked:        415
    Karma Level
    524

    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.Files.zip

  2. #2
    DF Probation Goldberg's Avatar
    Join Date
    Jun 2001
    Location
    Landaaaan!
    Posts
    14,453
    Thanks
    1,325
    Thanked:        1,547
    Karma Level
    1152

    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 VIP Member akimba's Avatar
    Join Date
    Jun 2006
    Location
    UK
    Posts
    2,846
    Thanks
    1,034
    Thanked:        783
    Karma Level
    369

    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 ;-)

    www.kimba.me.uk/excel/files.zip

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

Similar Threads

  1. gta3 save file 4 u all (pc)
    By neilmachin in forum PC Gaming
    Replies: 6
    Last Post: 14th January 2003, 01:52 PM
  2. Wicked Flash File
    By Pegasus in forum The Dog and Duck
    Replies: 11
    Last Post: 13th November 2002, 11:46 PM
  3. T100 To T108 Flash File
    By BAZZO69 in forum Unlocking Questions & Solutions
    Replies: 7
    Last Post: 4th September 2002, 07:53 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
  •