Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2009
    Posts
    5

    Unanswered: Export Excel timesheet to text file

    I have created a little code that will export exployees time to a text file, which is then imported into access for invoicing reports. The problem I am having is I dont know what other "write" command to use that will write the date as a date instead of a number, which is what is happening now.

    The file I have works, but I would rather it be written as "1/19/09" instead of 123456. When I import the number format into access, which column is formatted as a "date", I get an error.

    Any thoughts? Thanks.
    Attached Files Attached Files

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    So this is an Excel problem? I don't know if Excel's code is similar, but you might like to try exporting the expression Format(DateSource,"d mmm yyyy") or something similar.
    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

  3. #3
    Join Date
    Jan 2009
    Posts
    5
    Thanks, that's what I needed.

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Great!

    Glad I could help
    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
  •