Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2009

    Unanswered: csv file auto save to excel

    I have folder of my company's phone server and it consist of files save as CSV. I need to get a day to day file from the server (saved in csv type) and I want it to auto open and save to excel. Please if you have an idea, i need you help on this. On my form, i will supply the date of the day that we will need to get from the server.

  2. #2
    Join Date
    Nov 2007
    Adelaide, South Australia
    Try an Excel support forum??

    What has this got to do with Microsoft Access???

    Making a whole lot of assumptions, all you should need is a tiny bit of VBA to ask for a date then go and copy a file. Then that file just needs to be opened with Excel.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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