do not display system views - connection via Excel

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hello,

In excel, when I use GetExternalData Tool, I can access all the system
tables as listed below:

all_columns
all_objects
all_parameters
all_sql_modules
all_views
allocation_units
assemblies
assembly_files
assembly_modules
assembly_references
.....etc...
......
xml_schema_wildcards

I do not want to get this list as it is useless and It's hard to find
my views in this list.

I would like to get the list of the only Views I have created.

Do you know how to do that?

help much appreciated.

Chris



do not display system views - connection via Excel

.

Relevant Pages

  • Re: Problems referencing Excel using C# - urgent!
    ... I can access Excel 2000 as 'using Excel' and my project has a reference to ... > Primary Interop Assemblies ... if the PIA is installed in the ... > For detailed information about How the Runtime Locates Assemblies, ...
    (microsoft.public.dotnet.framework.interop)
  • Re: Custom Property Reader/Comparer
    ... be parts, assemblies, or drawings. ... I wrote one of these utilities that works as a VBA project in Excel. ... The limitations are: It doesn't retreive configuration ...
    (comp.cad.solidworks)
  • Re: Documents in differenet directory than Assemblies + template versus document
    ... about changing the location of the document and assemblies: ... When you open an Excel template, it creates a new document based on the ... > I'm finally able to deploy my Excel VSTO beta 2 app to different clients ...
    (microsoft.public.vsnet.vstools.office)
  • Re: Excel Automation
    ... I used the Record Macro function to record inputing names in 2 different ... where you can use Excel or Word as your UI. ... > assemblies, a whole new world of problems opens up, so I don't recommend it. ... PIAs save you all this hassle and more. ...
    (microsoft.public.dotnet.languages.csharp)
  • do not display system views - connection via Excel
    ... In excel, when I use GetExternalData Tool, I can access all the system ... I do not want to get this list as it is useless and It's hard to find ...
    (microsoft.public.sqlserver.odbc)