| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple worksheets in excel-need to knowif it canbe exported toac
I have multiple worksheets in excel which involves lot of calculations. Can
this be exported in access? Can you do calculations in access? Thanks, -- Gold |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple worksheets in excel-need to knowif it canbe exported toac
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) "gold" wrote: I have multiple worksheets in excel which involves lot of calculations. Can this be exported in access? Can you do calculations in access? Thanks, -- Gold |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data exported from Lotus approach to excel how do I show it in a u | Excel Discussion (Misc queries) | |||
| Word table exported to Excel | Excel Discussion (Misc queries) | |||
| How can I convert an exported UNIX timestamp in excel? | Excel Discussion (Misc queries) | |||
| Subtotals in Excel 2003 for doc exported from Sharepoint list | Excel Discussion (Misc queries) | |||
| exported excel charts and pdflatex | Charts and Charting in Excel | |||
Linear Mode
