Networks

Ask something
Question Locked

Importing Excel Files Using DTS

0 helpful
2 replies

by karthik.arjun

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How to move the particular table data to excelsheet in sql server through dts?

2 replies

by thumbsup2

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.

This discussion is closed to new replies.