How to insert data into an already created table

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

How to insert data into an already created table

Author

Topic

skybvi
Posting Yak Master

193 Posts

Posted - 2011-09-19 : 16:08:57

Hi,
One of my tables in a db has 6 columns and around 10,000 rows of data.
I have new data in an excel file with same first 4 columns and 1000 rows of data. I want it to be appended to the that table in the db.
For the last 2 columns i want it to be blank.
HOW is it possible.

Regards,
Sushant
DBA
West Indies

ehorn
Master Smack Fu Yak Hacker

1632 Posts

Posted - 2011-09-19 : 16:10:55

Hello Sushant,

You have several options for this task. The following article may help you find a solution;

http://support.microsoft.com/kb/321686

HTH.

skybvi
Posting Yak Master

193 Posts

Posted - 2011-09-19 : 16:24:49

@ehorn

Thanks dude.

Regards,
Sushant
DBA
West Indies

ehorn
Master Smack Fu Yak Hacker

1632 Posts

Posted - 2011-09-19 : 16:25:42

yvw,

Have a nice day.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources