If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Setting up a db
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 |
#2
|
|||
|
|||
Setting up a db
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 |
#3
|
|||
|
|||
Setting up a db
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) "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 |
Thread Tools | |
Display Modes | |
|
|