Dynamic Import from excell - 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

General SQL Server Forums

Script Library

Dynamic Import from excell

Author

Topic

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2005-09-14 : 15:41:08

hello All,
Am not sure if this is the right forum to post this. But here goes

I have a phone book, which users could enter numbers via a web interface and a SP.

However i was wondering how to generate a bulk insert script, that would

Import from an uploaded excell workbook to MS SQL
How could this be done

NOTE: Am doing an upload via an ASP page, then hoping that either the ASP page, via a SP or an SQL command Statement do a bulk copy for the user who uploaded it to my SQL table

difficult ???

Thanks Anyway
Afrika

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-09-15 : 01:54:54

>>Am not sure if this is the right forum to post this.

This is only to post workable Scripts

>>Import from an uploaded excell workbook to MS SQL

Have you checked this?
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Madhivanan

Failing to plan is Planning to fail