Question

  • Creator
    Topic
  • #2150643

    Importing Excel Files Using DTS

    Locked

    by karthik.arjun ·

    How to move the particular table data to excelsheet in sql server through dts?

All Answers

  • Author
    Replies
    • #2914218

      Clarifications

      by karthik.arjun ·

      In reply to Importing Excel Files Using DTS

      Clarifications

    • #2914094

      re: Importing Excel

      by thumbsup2 ·

      In reply to Importing Excel Files Using DTS

      Save the Excel file as a DOS based CSV file first, then import that file. That’s a text based comma separated file. Be sure to open the CSV file in Notepad to check for characters (such as ‘ or extra spaces) that will confuse the import.

Viewing 1 reply thread