hello I am having some problems with SQL server 2005 1) How To import excel file in SQL Server 2005 ??? I am using the DTS Package for data import and export. It always gives the error... I am not able to import the excel shit to SQL 2005 table.. This process works for SQL Server 2000
2) Also when I change some columns or add columns to table Every time i used to keep the track what i have changed using alter statement. I add the row to tables. If i script the table defination the table is newly created by dropping old table. Is There is any way alter table defination without loosing the data in the table. I am having 730 tables in my Data Base. When i release the version of my software every time i have to keep the track for all database and for all clients on which date which client is given the updation. I having more than 100 clients and 2 client companies also their clients. -- Rakesh Hendre, Sr. Software Engineer Brilliance Software Systems. Mob : 9960001862 -- You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to dotnetdevelopment@googlegroups.com To unsubscribe from this group, send email to dotnetdevelopment+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en or visit the group website at http://megasolutions.net