trying to extract Access database to Excel report... HELP !

[DWW]

Heh, well I'm trying to create a pivot table and pivot chart report in Excel using data stored in Access files (.mdx, .dbf, .dbt) I think.

Well anyhow, its really whack and I'm having trouble. It was so easy to extract data from Analysis Manager cubes and use that, it would then have each "dimension" reasibly available to drag and drop.

Grrr any clues? :\

If I import the data it just blobs a single dimension on the whole spreadsheet which I DONT want.

When I try to get data from an external source for the pivot table and charts, it only allows .mdb files for Access...

What should I do?

 

[GeekDrew]

I've never heard of mdx dbf and dbt files for Access... I've only heard of mdb files (for independent offline databases).

 

[DWW]

hrm...weird... this blows anyhow ;(

 

[DWW]

I can't fscking extract it properly...grrrrrr

this is making me very angry

I hate database oriented classes.... most people who take em at school are either the business type or the ones would couldn't cut it in the C/C++/Java classes... I took it cause I needed a credit ;(

 

[DWW]

think the dbf and dbt files are some sort of connection things

renamed the mdf to mdb so i hope it works...

 

[alkemyst]

dude three posts in a night on basic excel? get a book or hit the web.