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

  • Thread starter Thread starter gold
  • Start date Start date
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,
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to calculate hrs flown in last one year 0
Exporting Data from MAS500 into Excel problem 4
combine worksheets 1
Counting multiple memberships 1
Excel 2007 time calculation 1
replace all formulas with values in multiple worksheets 5
VBA / Macro Help Please 2
Converting multiple rows of Excel data into Word Document 1

Back
Top