locked
how to import data from excel to sql server table RRS feed

  • Question

  • User-556790531 posted

    how to import data from excel to sql server table   

    here  i am  having table value in excel file  i want to  get  the value  to sql  table   whether  i want to use  import  or export

    and briefly  explain  how i should do this 

    Tuesday, December 27, 2011 10:45 AM

Answers

All replies

  • Tuesday, December 27, 2011 10:47 AM
  • User-556790531 posted

    i have found data cound not  get string retrevial data from a

    Wednesday, December 28, 2011 5:29 AM
  • User498534395 posted

    Try the following link

    http://www.66pacific.com/sql_server_import_from_excel.aspx

    This link will surely help ur need...

    If not reply me..

    Wednesday, December 28, 2011 5:41 AM
  • User-556790531 posted

    i found error like this

     

    TITLE: SQL Server Import and Export Wizard
    ------------------------------

    Cannot get string literals from the database connection "Provider=microsoft.ace.oLeb.12.o;
    dataSource=c:\documents and settings\pc1\my documents\err.xlsx;
    Extended Properties="exel 12.0;hdr=yes"",.

    ------------------------------
    ADDITIONAL INFORMATION:

    couldnot load file OR assembly"microsoft.sqlserver.diagonstics.strace,
    version=10.0.0,culture=neutral,public keytoken=89845dcd8080cc191'.

    ------------------------------
    BUTTONS:

    OK
    ------------------------------


    Wednesday, December 28, 2011 7:26 AM
  • User498534395 posted

    Please Check ur excel

    I think some problem might be with that only

    Wednesday, December 28, 2011 7:37 AM
  • User-2139489267 posted

    how to import data from excel to sql server table   

    Please don't create duplicate threads.

    Wednesday, December 28, 2011 7:39 AM
  • User1508394307 posted

    couldnot load file OR assembly"microsoft.sqlserver.diagonstics.strace

    Please check this.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, December 28, 2011 8:28 AM
  • User1999579388 posted

    Hi sivaganesh1234,

    I found this thread which got the same error like you. It may help you.

    Please see: http://social.msdn.microsoft.com/Forums/en/sqltools/thread/1600dea6-a434-4cfb-87ce-472018cf64fd

    Thanks.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, December 29, 2011 5:46 AM