Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel as Data Source

Status
Not open for further replies.
omarmtz

omarmtz

Programmer
Joined
Nov 22, 2002
Messages
75
Location
MX
Is there a way to import the data of an Excel sheet??
 
Sort by date Sort by votes
No. Unless you put it into Access and the rest of your data is there also.
 
Upvote 0 Downvote
there's a strange way to do it. If you are using a db, it probably has a way to "link" external data. For example in MSAccess, you can link to an excel spreadsheet thru file..get external data ..link. Then pick your Excel data. The excel data becomes a live table that you can add to the MSTR project.

Not the best but works.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

newbie2009
  • Locked
  • Question Question
How to access data from a REST Url with Microstrategy Xquery
Replies
0
Views
402
newbie2009
newbie2009
jhmoen
  • Locked
  • Question Question
Exporting to Excel
Replies
1
Views
288
Mscherer
Mscherer
edesantis08
  • Locked
  • Question Question
How to use a filter as a marker
Replies
0
Views
225
edesantis08
edesantis08
dinzana
  • Locked
  • Question Question
Comparing sysdate()-1 to another date in multiple datasets in a report document.
Replies
0
Views
443
dinzana
dinzana
jadr
  • Locked
  • Question Question
Line graph displays too much data
Replies
0
Views
199
jadr
jadr

Part and Inventory Search

Sponsor

Back
Top