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

Transact-SQL (2005)

Import data from Excel

Author

Topic

GuanWe
Starting Member

2 Posts

Posted - 2011-03-03 : 10:00:18

Hello,

how do I append data from Excel to an existing tables in SQL using:

1. SQL in stored procedure, assuming I run this often; or
2. In VBA

thank you!

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2011-03-03 : 10:55:35

Refer this
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources