I have an online database, in Access 2000 format, Stock. mdb.
i need to download the data in the database into MS EXCEL, MAKING use of MS EXCEL as an interface and also analyze the data in pivot table. (everytime i click on update button from the Excel Interface, the data would be downloaded from the online server into the Excel offline)
First of all, how do i create that link from Online server to my MS Excel interface? Secondly, do i need to create a so called "cube" to contain all the data in MS Excel?
PLease help me..