Import data from Excel to SQL Server 2005
 

Hi
Where is the best forum to get and answer to this question?
If it is here - Cool :-)

All I want is a proven code that can take data from an Excel worksheet
- ie a small table of 4 columns of data only 20 rows long and put it
into an SQL Server database

I have a DSN connection I wish to use

Set dbs = OpenDatabase("MySERVER", dbDriverComplete, True,
"ODBC;DATABASE=DSNConnection;;;")

I would like to use ADO or DAO?

Tried things from other posts but get errors.

Any help appreciated.
Thanks
Dominic