Setting up a db

[H]

Hi - I need to setup some kind of a database that we update monthly but use
the data in Excel and want to find the most effecient way to do this.

The data is pulled from Business Objects (currently it is being copied into
Excel and updated each month but the files are getting to be too big) we
still need to have the ability to do pivots in excel with this data and was
wondering if it would be more effecient to copy the data from Business
Objects into Access and then somehow access the data in access but using
excel ?? Is this doable and what is the best way for me to start this?

Thank you

 

[NG]

Hi H,

it's perfectly possible to update the data in an Excel file. Each month you
can import the new data and then use update/append/delete queries to do the
monthly update in the tables.
If you're using Access 2007 you can design a form in pivot view to view the
data, but if you want ,you can export query results to Excel to pivot there
without any problem.

 

[H]

Thank you!!! The new version of Access is very different from the old -- any
good tips? Will Access have the same capabilities of excel doing these
formulas? Do you know how I should rewrite them for Access -- Thank you!!!


Annnual Fees: ([Total Fees] / [Mos])*12 =IF(T329=0, "", 12*X329/T329)
Discount: ([List Price]-[Total Fees])/[List Price] =(W329-X329)/W329
Access Rate: (12* [Total Fees] / [Mos] / FRP) =IF(ISERROR(12*X2/T2/V2), "",
12*X2/T2/V2)