Welcome to Sign in | Help

Re: Import .dbf in SQL Server 2005

  •  11-28-2006, 11:32 AM

    Re: Import .dbf in SQL Server 2005

    SELECT * FROM OPENROWSET(
       'MSDASQL',
       'Driver={Microsoft dBase Driver (*.dbf)};DBQ=C:\Temp\',
       'Select * from import');

    Msg 15281, Level 16, State 1, Line 1


    SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Ad Hoc Distributed Queries' by using sp_configure. For more information about enabling 'Ad Hoc Distributed Queries', see "Surface Area Configuration" in SQL Server Books Online.


    MCSE;MCITP
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems