excel formulas to access tables

  • Thread starter Thread starter Tara
  • Start date Start date
T

Tara

I rather use access to enter my information, but I am
getting my final numbers from an formulas generated in
excel.

Is there a way to create a form which has the same
properties as an excel file with excel forumlas and have
that form feed directly into a table to update individual
reports in my master table?


thanks
 
Not really.
As I recall Access does not like to import files with formulas in them.
So a copy/paste special (as values only) to a new worksheet would work.
Then import that data.
 
Back
Top