Importing Excel Files Using DTS

By karthik.arjun ·
How to move the particular table data to excelsheet in sql server through dts?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

re: Importing Excel

by ThumbsUp2 In reply to Importing Excel Files Usi ...

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.

Related Discussions

Related Forums