sql server - Confused by Excel ODC connection files -


so making new connection ms sql server using wizard , realized don't know why has me save these odc connection files.

so, , why excel create them?

further, happens these files once when change connection selecting table, custom sql statement have created?

does change in these odc files? know complains if make change no longer match stored in file.

edit:

i decided 1 of odc files , html combined xml tags , little javascript. interesting. still not sure how excel uses these files instead of storing data itself. guess provide connections multiple workbooks.

i think idea can share these files. put odc on network share or on sharepoint, have multiple workbooks use odc file, , if updates necessary (like database moved), have change in on place.

also, if double click odc file, create new workbook connection , table. guess lean way of sending workbook consists of external data table access same connection. haven't used myself, but, know, theoretically...

why did choose default? don't know. wouldn't have. have chosen have data stored in excel, still have ability export odc want go route. i'll bet vast majority of external data tables have odc sitting in documents , user isn't aware of it.

but pre-tablet ms office seemed base design decisions on biggest clients wanted. , since there isn't cost average user (other warnings may not understand), why not.


Comments

Post a Comment

Popular posts from this blog

searchKeyword not working in AngularJS filter -

i writing app using angularjs on front end. want search through table word/field; 1 search box everything. according article here: http://hello-angularjs.appspot.com/searchtable can use filter: searchkeyword this. this code, , not working expected. <label>search: <input ng-model="searchkeyword"></label> <table ng-repeat="post in posts | orderby: sort | filter: searchkeyword"> <tr> <td> {{index(post)}} </td> <td> {{post.title}} </td> <td> {{post.author}} </td> <td> {{post.content}} </td> <td> {{post.date | date: "d/m/yyyy"}} </td> </tr> </table> what should do? thank you try this: controller $scope.posts = [ {title:'title one', author:'author one', content: 'content one'}, {title:'title two', author:'author two', content: 'cont...
Read more

sequelize.js - Sequelize: sort by enum cases -

i have model ( article ) field (the name type ) of type enum('source', 'translated') , return 1 article ordered type field. source articles should returned before translated articles. like: article.findone(order: [ { type: [ 'source', 'translated' ] } ]); unfortunately there appears no built-in solution sorting enums. instead have sort by case , couldn't find documentation on how sequelize. what conventional approach here? sorting case hard in sequelize, sort field (the second answer in linked post) should possible: order: sequelize.fn('field', sequelize.col('type'), 'source', 'translated') it's supported mysql far know though
Read more

user interface - how to replace an ongoing process of image capture from another process call over the same ImageLabel in python's GUI TKinter -

i trying use following code create interactive gui changes color-space(hsv, rbg, grayscale etc) on event of button click. display opencv video in tkinter using multiprocessing being new python having problems multiprocessing , attempts on making gui change it's color space on button clicks hangs entire system. on it's implementation highly appreciated. thankyou. below code: import cv2 pil import image,imagetk import tkinter tk import numpy np multiprocessing import process , queue def quit_it(root,process): root.destroy() process.terminate() def black_andwhite(root,process): process.terminate p=process(target=capture_image, args=(5,queue, )) p.start() root.after(0, func=lambda: update_all(root, image_label, queue)) def update_image(image_label, queue): frame = queue.get() = image.fromarray(frame) b = imagetk.photoimage(image=a) image_label.configure(image=b) image_label._image_cache = b root.update() def update_all(root...
Read more