Importing excel spreadsheets while retaining formula functionality.

[Yurimeta19]

Ok so here is my problem. I have been tasked with importing data within a massive excel spreadsheet into access. Importing it, no problem, keeping all the functions available so that those people who need to use them are able to do so in access (problem)

I have yet to learn how to do this. The basic reason for the import in the first place is that the excel file is so massive it takes too much time to load and get anything done in a timely manner.

If anyone has any suggestions or solutions the problem at hand I would appreciate it very much.

[ConneXionLost]

Most Excel formulas don't work in Access, so you still have a problem. But, post a "sample" of your spreadsheet (enough to see how the formulas are set up, and no confidential materiel).

Cheers,