convert .csv file to .cub using access

[John Johnston]

I am using Microsoft Access to work with a .CSV file that
contains 250,000 rows of information. I'd like to
convert that file to a .CUB file so that I can use
Microsoft Data Analyzer to "drill" down the information.
Does anyone have any ideas?

 

[John Nurick]

Hi John,

As I understand it, the normal way would be to use the Cube Wizard in
the OLAP Manager, after importing and normalising the file into SQL
Server tables. It may be possible to use the Cube Wizard against an ODBC
connection to an MDB file.

But as I understand it the point of using OLAP cubes is to denormalise a
set of views of a big data set. If you've only got one CSV file of only
250,000 rows it's hardly a big data set, and it's already denormalised.
What can Microsoft Data Analyzer do that Totals and Crosstab queries
can't?

I am using Microsoft Access to work with a .CSV file that
contains 250,000 rows of information. I'd like to
convert that file to a .CUB file so that I can use
Microsoft Data Analyzer to "drill" down the information.
Does anyone have any ideas?

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.