Welcome to Sign in | Help

Re: import date din excel (file local) pe un 2005 server sql nelocal

  •  08-26-2010, 12:51 PM

    Re: import date din excel (file local) pe un 2005 server sql nelocal

    Pentru OPENROWSET, vezi daca "Ad Hoc Distributed Queries" sunt admise pe serverul tau:
    sp_configure 'show advanced options', 1
    RECONFIGURE
    sp_configure
    si vezi valoarea Ad Hoc Distributed Queries. Daca e 0,
    sp_configure 'Ad Hoc Distributed Queries', 1
    RECONFIGURE
    Pentru linked server sunt mai multe de incercat
    http://connect.microsoft.com/SQLServer/feedback/details/284113/import-excel-data-with-openrowset-on-production-server
    http://support.microsoft.com/kb/814398
    http://nathondalton.wordpress.com/2010/04/01/sql-memory-and-external-data/
    Poti avea acces la datele respective in format csv sau text, pentru bcp?
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems