By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,423 Members | 1,294 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,423 IT Pros & Developers. It's quick & easy.

Help loading data from Excel to Analysis Services

P: n/a
I have a 40 MB database in excel format.
I need to use it in Analysis Services, I imported the data by DTS (Data
Transformation Services), everything is working I can see the database,
but I can't load it in the analysis services.
I have to construct a cube but I can't see the database in any way I
tried.

Thank you
I hope my message is quite clear
Hope to find somebody that can answer me in Italian, but English is good
as well.
Jul 20 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a


Daniele wrote:
I have a 40 MB database in excel format.
I need to use it in Analysis Services, I imported the data by DTS (Data
Transformation Services), everything is working I can see the database,
but I can't load it in the analysis services.
You imported it into what? SQL?
I have to construct a cube but I can't see the database in any way I
tried.
Have you refreshed your data connection in analysis services? Right
click on the data source and select refresh.

Thank you
I hope my message is quite clear
Hope to find somebody that can answer me in Italian, but English is good
as well.


Sorry, only know English ;)

Zach
Jul 20 '05 #2

P: n/a
Zach Wells <in*************@nibsworld.com> wrote:
Daniele wrote:
I have a 40 MB database in excel format.
I need to use it in Analysis Services, I imported the data by DTS (Data
Transformation Services), everything is working I can see the database,
but I can't load it in the analysis services.
You imported it into what? SQL?


I need these data into SQL Server 2000 Analysis Services, but the only
software that can load an Excel file is Analysis Manager that have a
Data Tranformation Services as a tool in the mený bar.
I found my data in the Master Database in the server as a table
Have you refreshed your data connection in analysis services? Right
click on the data source and select refresh.


I have done it. The data should appear in the local database, is it
right ?
I'm thinking about create an Access file (.mdb) but no import utility is
included in Access so I have to copy and paste all my rows (44000).
Is there an easier way

Thank you Zach sorry for my not very technical English
Jul 20 '05 #3

P: n/a
Daniele wrote:

I have done it. The data should appear in the local database, is it
right ?


Not really, no. The only data that is in your analysis services database
is cube data. What you have to do is create a new cube. When you create
the new cube it will provide you with a list of all the tables that it
sees via the data source connection you defined. You select the table
you want to use as the source of your cube data here.

Zach
Jul 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.