Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
infodemers
Posting Yak Master
183 Posts |
 Posted - 2010-05-04 : 08:51:28
|
I have found a solution :Set objexcel = CreateObject("Excel.Application")objexcel.Workbooks.Open file1Set objsheet = objexcel.ActiveWorkbook.Worksheets(1)objsheet.Columns("A").EntireColumn.InsertHi,Before I can import the data from my excel file into my DB, I need to insert a column to the left of the A column. Any idea how i could get it done from my ActiveX script in a DTS?Thanks for any help! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-05-04 : 13:05:58
|
| can i ask the need of this column in excel? is it for generation of sequence number or something?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Insert Column in Excel file