Discussion Locked

Exporting/Importing

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi All!
I have a spreadsheet with calculations in it that needs to be imported into Access 97. The problem is that when I import the spreadsheet into Access the calcuations do not carry over. Is there some kind of formula that can be written in Access to calculate those fields? Thanks for any insight that you gurus may have.

3 replies

by dklippert

In general, when using Access, the tables hold static data and Queries are used to calculate and display results. ALMOST all of Excel's functions will work in Access.

This discussion is closed to new replies.