Import data from Excel - SQL Server Forums

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 2000 Forums

Import/Export (DTS) and Replication (2000)

Import data from Excel

Author

Topic

swatib
Posting Yak Master

173 Posts

Posted - 2006-05-02 : 02:55:53

I've doubt regarding Data Import feature of Sql Server.

Suppose I have an excel file with data and want to import it in sql server's one table. But the table has extra columns like primary key, Addedby, Addedon etc So how to import the data in such cases?

while iserting these data into that table the application itself inserts the primaykey and the listed other column data.

please guide me over this.

Thanks

Njoy Life

m.ibbrahim
Starting Member

16 Posts

Posted - 2006-05-02 : 08:33:29

Hi Swati,
In "DTS Import/Export Wizard", you will come across "Select Source Tables and Views". In this you can select Transform and map the fields of Excel sheet to the required Database field.

Give it a try..

Regards
Mohd.Ibrahim

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-05-02 : 09:17:16

You can try this also
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Madhivanan

Failing to plan is Planning to fail

swatib
Posting Yak Master

173 Posts

Posted - 2006-05-03 : 04:35:44

Thanks........I'll try

Njoy Life

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources