Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005
    Posts
    119

    Unanswered: TSQL Statement to import data from Excel File to MSSQL 2000 table

    Is it possible in a TSQL statement that would import data from excel file to MS SQL 2000 table? I know i can do this by using the DTS Import/Export wizard but i'm wondering if a simple TSQL query can do the job. I'm using a tool/software that connects to SQL server but I can only execute TSQL statement. Thanks a lot.

    Sort of...
    INSERT INTO SQLTable
    SELECT FROM ExcelFile

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Just about every variation here:
    SQL Server Forums - Export to Excel
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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