| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| import data into SQL Server from Excel | Excel Discussion (Misc queries) | |||
| how to make Excel linked to SQL Server 2005 worksheet editable? | Excel Discussion (Misc queries) | |||
| How to connect the Excel 2007 in SQL Server 2005? | Excel Worksheet Functions | |||
| How do you import many EXCEL worksheets into AutoCAD 2005 drawing | Excel Worksheet Functions | |||
| How to import data from SQL Server | Excel Discussion (Misc queries) | |||
Threaded Mode
