View Poll Results: plz plez ples please ,sos

Voters
1. You may not vote on this poll
  • how are u

    1 100.00%
  • how u study

    0 0%
Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2012
    Posts
    6

    Angry Unanswered: Importing date from excel to sql server 2000 error



    MY problem irrirates me v mutch when i use this statment :
    Select * into SQLServerTable FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=D:\Libya Fiyat Çalışması.xls;HDR=YES', 'SELECT * FROM [libya$]') for exaple ?

    this statment work v good in sql query analyzer

    but when i use this code in stored procedure in my datebase like:

    SET ANSI_WARNINGS on
    SET QUOTED_IDENTIFIER ON
    SET ANSI_NULLS ON
    if @state=0
    BEGIN
    Select * into SQLServerTable FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=D:\Libya Fiyat Çalışması.xls;HDR=YES', 'SELECT * FROM [libya$]')
    END
    SET ANSI_WARNINGS off
    SET QUOTED_IDENTIFIER OFF
    SET ANSI_NULLS ON


    Everytime I try to save the procedure I get "error 7405: Heterogenous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection."

    please i want solusion for my prblem
    note : i used sql server 2000

  2. #2
    Join Date
    Aug 2004
    Location
    Dallas, Texas
    Posts
    831
    See my answer is previous question.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •