Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Analysis Services (2000)  Importing excel into OLAP analysis services

Author  Topic  Eric001 Starting Member 1 Post Posted - 2004-08-27 : 05:13:00 Hi, I am trying to import an excel file into MS SQl analysis service. I have already connected the excel file in the ODBC admin. From the data-sourse tab In analysis service, i use ODBC to select the excel file. However, when i try to create a cube, no data is shown, like it is not getting information from the file. Do you know if there are any setting that i may have missed while configuring my excel for ODBC.