Hi all,
I have a large Excel file with one large table which contains data, i've built a SQL Server DataBase and i want to fill it with the data from the excel file.
How can it be done?
Thanks, Michael.
If you are using SQL 2000 Standard or better, use DTS.
If you are using SQL2005/8 Standard or better, use SSIS.
If you are using SQL 2005/8 Express, get the Graphical User Interface for it and try that out.
p.s. What version of SQL Server are using?
No comments:
Post a Comment