Import data from Excel to SQL Server 2005

D

dlorenz7

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Merging from an Excel file with graphics 1
Exporting Data From Excel to SQL 2
How to Get Filtered Data from SQL server into Microsoft Excel 2007 5
Excel Windows Authentication to SQL Server 1
moving _be to sql server 2005 8
ODBC connection from Excel 2008 on Mac OS X 0
Excel and SQL Server 1

Top