Crunch numbers with MS Access: is this possible?

[Rui Maciel]

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

 

[Douglas J. Steele]

Yes, it should be possible. You can do simple arithmetic in queries.

 

[Rui Maciel]

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