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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-05 : 07:58:37
|
| daniel writes "Hi,I want to import data from ms-excel into sql server7.0 using visual basic programattically.That is by reading the excel file and putting the data in to the table.thankyou" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-04-05 : 08:29:11
|
| Data Transformation Services (DTS) has a very rich object model that can be programmed in VB or C++. The documentation for it is in Books Online (main contents tab, "Building SQL Server Applications", "DTS Programming") There are also some DTS code examples installed when you install SQL Server, hunt around in the SQL Server program folder for "Tools", "DevTools", "Samples" etc. and you'll find the folder where they are (may need to unzip the package)This site is pretty good on DTS programming too:http://www.sqldts.com |
 |
|
|
|
|
|
Importing data from excel to sqlserver 7.0 using Visual basic