you can use SQL Server Import and Export Wizard. Then write a query to specify the Data transfer (Which columns should be added).

BEGIN TRAN

INSERT INTO Table2

SELECT*

FROMTable1

DELETE

FROMTable1

COMMIT

GO

This code will do the trick...

But one question mate.... Why don't you just develop Form (Application), where the user can add records?

John Marsh (5/5/2009)

---

Hello,

I don’t believe there is inbuilt functionality to script out the Insert statements for all the data in a Single Table, but there are third party tools which...

You can use this code TEMPORARILY

declare @abc table

(

Applicant char(20),

Skills1 char (20),

Skills2 char (20),

Skills3 char (20),

Skills4 char (20),

Skills5 char (20),

Skills6 char (20)

)

insert into @abc

select 'Jones',...

Hi jewel,

Have you tried browsing it manually?

or tried typing the instance manually?

GSquared (4/28/2009)

---

If you want to convert a string like that to a time, then I recommend this method:

declare @Time int;

select @Time = 123757;

select dateadd(second, @Time%100, dateadd(minute, @Time%10000/100, dateadd(hour, @Time/10000, 0)))

Just...

it might be better if you could give sample table and data where we can work with...

but seeing the sample data you provided, it seems that there is no normal...

You might want to add sample data we can work with so we can clearly understand what you want..

vaibhav.a (4/20/2009)

---

i want to perform this task using stored procedure, as I have to insert data in multiple table from multiple excel files at a time...

plz help me

thank...

vaibhav.a (4/20/2009)

---

Hello,

Please help me,

I am having having excel file and i want to transfer data from different excel files into multiple tables..........

First I want to know is this possible...

jose_anisha (4/19/2009)

---

I have a huge table to which i need to add new columns periodically....also i have and array temp() which contains the new set of columns to be...

sward (4/19/2009)

---

Hi,

I am running a distinct query that was working fine. as soon as i added a new field(ilr.unique_ilr_id,)to be displayed in the reults the distinct part stops working and...

jaimepremy (4/18/2009)

---

Hi there,

I'm having a hard time rounding avg results upwards (underlying dataype is int).

For example if the sum of 3 rows = 8, then avg should be 3 since...

arun.sas (4/14/2009)

---

hayzer (4/14/2009)

---

hayzer (4/14/2009)

---

try this code...

suppose you have the table 'tblNames' with a column 'name'

select left(name,charindex('-', name)-1)

from tblNames union all

select left(name,charindex('/', name)-1)

from tblNames

havent tried it... i'll try this...

hayzer (4/14/2009)

---

try this code...

suppose you have the table 'tblNames' with a column 'name'

select left(name,charindex('-', name)-1)

from tblNames union all

select left(name,charindex('/', name)-1)

from tblNames

havent tried it... i'll try this code at...