Setting up a db

H · External Since: Mar 01, 2009 Posts: 8

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 · External Since: Aug 07, 2009 Posts: 5

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.
--
Kind regards
Noëlla

"H" wrote:

> 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

H · External Since: Mar 01, 2009 Posts: 8

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!!! Smile

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)

"NG" wrote:

> 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.
> --
> Kind regards
> Noëlla
>
>
> "H" wrote:
>
> > 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