Export excel 2003 formula to access 2007

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Lina Arraiz
    New Member
    • Jul 2010
    • 3

    Export excel 2003 formula to access 2007

    First of all, my apologies for originally posting this question in the wrong section. I'm trying to export an Excel 2003 spreadsheet to Access 2007. Column D (START) has the start time and Column E (END) has the end time.
    I need to calculate the time elapsed between these two columns with the results appearing in column F (TIME). I don't have dates in my Excel spreadsheet, just times: 8:00:00 AM. The result comes out in Column F like this: -0.75. The Excel formula I've placed in column F is the following:

    =24*(IF(E2>D2,D 2-E2))

    Exactly what language do I use in my Access database in order to get the same results that I have in my Excel spreadsheet and where do I put it? I appreciate your help as I'm totally stumped!
  • Jyoti Ballabh
    Banned
    New Member
    • Jul 2010
    • 115

    #2
    export of a report to excel is no longer possible but you can transfer a table or a query.

    Comment

    • Lina Arraiz
      New Member
      • Jul 2010
      • 3

      #3
      Excell 2003 to access 2007

      Sorry, I meant FROM Excel TO Access. Would I do that by adding a query to my Access database? What language do I use? Thanks again!

      Comment

      Working...