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!
Lina Arraiz
Last Activity: Jul 26 '10, 07:06 PM
Joined: Jul 22 '10
Location:
-
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:... -
Export excel formula to access
I'm trying to export an Excel 2003 spreadsheet to Access 2007. I need to calculate the time elapsed between column D (START) and column E (END) with the results appearing in column F (TIME). The Excel formula, which is placed in column F, goes like this: =24*(IF(E2>D2,D 2-E2)) Exactly what language do I use in Access and where do I put it in order to get the same results? I appreciate your help ... I'm totally stumped!
No activity results to display
Leave a comment: