1. What error do you get while importing the "excel shit" ?? Why don't you research that error ?
2. If you change table schema of production databases (and frequently, at that), it's a sad story indeed. On Mar 13, 9:37 am, The Master Mind <rakesh.hen...@gmail.com> wrote: > 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
