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 gkittelson 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
Nov 22, 2002
75
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
How to access data from a REST Url with Microstrategy Xquery
Replies
0
Views
157
newbie2009
newbie2009
jhmoen
  • Locked
  • Question
Exporting to Excel
Replies
1
Views
117
Mscherer
Mscherer
edesantis08
  • Locked
  • Question
How to use a filter as a marker
Replies
0
Views
89
edesantis08
edesantis08
dinzana
  • Locked
  • Question
Comparing sysdate()-1 to another date in multiple datasets in a report document.
Replies
0
Views
167
dinzana
dinzana
jadr
  • Locked
  • Question
Line graph displays too much data
Replies
0
Views
74
jadr
jadr

Part and Inventory Search

Sponsor

Back
Top