How to insert files into SQL server from Excel using VB?

[rameshr]

Hi,
I am new to Vb. Can anyone help me in inserting data from a Excel sheet into a SQL-
Server 70 database using VB.

Thanx in adv,
Ramesh

ODBC has an EXCEL driver and a SQL7 Driver. you can transfer the data using ado objects. Or also you can set up a dts package in SQL7 to import the data autmatically as a scheduled package.

[sarath_777]

the easiest way, is to import the
data from comman delimited file into
SqlSever tables using BCP utility
.. I used this in
SQLSERVER 6.0 .. i dont know what this BCP
utility is called in version 7.0

The data in Excel can be saved as a
comma Delimited file..

sarath

[Clunietp]

In SQL 7, you can use the DTS wizard