client server - Export Excel connection to Access - .ODC info to .ODBC -


i have lots of data wrangle , need help.

i have been using excel file has 2 worksheets of interest me. each produce olap pivot table data need work with. move (.odc) connections access queries don't have hand paste of info out , manipulate , go through whole process several more times.

one table throughput (number of parts through operation(s)) part number , date. other hours logged @ operation(s) part number , date. have master list of part numbers more data have mix in.

biggest problem: each chart producing own subset of dates , part numbers have take care match data run calculations. i've tried:

  • by hand. got tired real quick.
  • using lookup, vlookup, match indirect , sorts of tricks.

it's mess. i'm confident if can put original pivot tables access can add few joins , write couple queries , turn out beautifully.

worst comes worse can copy/paste pivot table data access hand, if want change or expand data set? i'd rather work raw data.

edit:

the data held on sql server , cannot change that.

the excel pivot tables use .odc file connection. gives following connection string: 

provider=msolap.3;integrated security=sspi;persist security info=true;initial catalog=[mycatalog];data source=[mysource];mdx compatibility=1;safety options=2;mdx missing member mode=error  provider=msolap.4;integrated security=sspi;persist security info=true;initial catalog=[mycatalog];data source=[mysource];mdx compatibility=1;safety options=2;mdx missing member mode=error

(i replaced actual catalog , source)

can use .odc file information create pass through query in access?

have consider using proper olap server?

comparison of olap servers

once setup you'll able connect excel's pivot table server (as other reporting tools).


Comments

Post a Comment

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

i trying find efficient way previous revision of file text comparison using sharpsvn. using (svnclient c = new svnclient()) { c.authentication.defaultcredentials = new networkcredential( configurationmanager.appsettings.get("svnserviceusername") , configurationmanager.appsettings.get("svnservicepassword") , configurationmanager.appsettings.get("svnservicedomain") ); c.authentication.sslservertrusthandlers += new eventhandler<svnsslservertrusteventargs>(authentication_sslservertrusthandlers); collection<svnfileversioneventargs> fileversioncollection = new collection<svnfileversioneventargs>(); svnrevisionrange range = new svnrevisionrange(0, this.hooks.revision); svnfileversionsargs args = new svnfileversionsargs(); args.retrieveproperties = true; args.range = range; foreach (svnchangeitem item in log.changedpaths) { string path = this.repositorypath + it...
Read more

c++ - Is it possible to compile a VST on linux? -

for class project i'm attempting write vst plugin backed cuda. current cuda workflow on linux box, i'd prefer compile , link there. according wikipedia , should possible (i couldn't find steinberg documentation relevant linux) can't find makefile or instructions on how build if aren't using xcode or visual studio. i'm vst 3 sdk doesn't support linux. when try compile plugin under linux, error: ./base/source/fatomic.cpp:39:30: fatal error: libkern/osatomic.h: no such file or directory this issue caused following code in "vst3 sdk/base/source/fatomic.cpp" #if mac #include <libkern/osatomic.h> #if mac_os_x_version_min_required > mac_os_x_version_10_4 #define native_atomic_type (volatile int32_t*) #else #define native_atomic_type (int32_t*) #endif #elif windows #include <windows.h> #endif but hope compiling under linux work vst sdk 2.4. reading. jvstwrapper seems run on lin...
Read more

url - Querystring manipulation of email Address in PHP -

i using third party application (email2http) send me emailid, body , message. unable retrieve email id due name appended on , enclosed < , >. here querystring getting. test.php?from=ajay+reddy &subject=cx&body=somebody when print variable in php returns name , not email id. $from = $_get['from']; echo $from; //output ajay reddy please suggest me how can emailid also. i dont want use post method due testing , debugging. it's working fine. forgot use htmlentities() in debugging.
Read more