If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Crunch numbers with MS Access: is this possible?
I have an Excel spreadsheet which consists of two tables, one with a
list of tensions measured in specific nodes and another with the list of nodes and their coordinates. Is it possible to import that spreadsheet into Access and, with that data, perform some simple number crunching such as adding both tensions and distances? Thanks in advance, Rui Maciel |
#2
|
|||
|
|||
Crunch numbers with MS Access: is this possible?
Yes, it should be possible. You can do simple arithmetic in queries.
-- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele (no e-mails, please!) "Rui Maciel" wrote in message ... I have an Excel spreadsheet which consists of two tables, one with a list of tensions measured in specific nodes and another with the list of nodes and their coordinates. Is it possible to import that spreadsheet into Access and, with that data, perform some simple number crunching such as adding both tensions and distances? Thanks in advance, Rui Maciel |
#3
|
|||
|
|||
Crunch numbers with MS Access: is this possible?
On May 19, 6:26*pm, "Douglas J. Steele"
wrote: Yes, it should be possible. You can do simple arithmetic in queries. Nice. I've just found out about queries and it appears that at the very least it can do some preprocessing work. The learning curve appears to be a bit steep, though, as you can only do so much with a mouse. Thanks for the help, Rui Maciel |
Thread Tools | |
Display Modes | |
|
|