Tag Info

New answers tagged

0

Dim tmpArr As Variant Dim Cell As Range For Each Cell In Range(("B1"), Range("A1").End(xlDown)) If InStr(1, Cell, ",") <> 0 Then tmpArr = Split(Cell, ",") Cell.EntireRow.Copy Cell.Offset(1, 0).Resize(UBound(tmpArr), 1). _ EntireRow.Insert xlShiftDown Cell.Resize(UBound(tmpArr) + 1, 1) = ...


2

Step1: Create Function create Function [dbo].[fnSplit] ( @List varchar(8000), @Delimiter char(1) = ',' ) Returns @Temp1 Table ( ItemId int Identity(1, 1) NOT NULL PRIMARY KEY, Item varchar(8000) NULL ) As Begin Declare @item varchar(4000), @iPos int Set @Delimiter = ...


0

You can use bcp command utility to achieve. You can query your needed data from your table to a text file or csv file and then use bulk insert to read the same data from the file to the required table. The example below demostrated that: bcp "Select StudentNumber,Subject From [Your tableName] Order by Name"queryout StudentList.txt -C-T That will read ...



Top 50 recent answers are included