Multiple worksheets in excel-need to knowif it canbe exported toac

G

gold

I have multiple worksheets in excel which involves lot of calculations. Can
this be exported in access? Can you do calculations in access?

Thanks,
 
S

Sheeloo

You need to put all the data in one sheet (there was a post today on how to
do it)..
before exporting to Access...

In a database like Access you are NOT supposed to keep calculated columns (I
believe you CAN if you want, I need to verifty though). Calcualtions are
usually part of reports...

Ofcourse you can export calculated columns to Access where they will be
treated as values... meaning it will NOT change if you change the source
column(s)
 
Top