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

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" <(E-Mail Removed)> wrote in message
news:e01315e2-7864-48db-847e-(E-Mail Removed)...
>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

On May 19, 6:26*pm, "Douglas J. Steele"
<NOSPAM_djsteele@NOSPAM_gmail.com> 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