| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Porting of Excel data to SQL Server 2000 remotely
I have an excel sheet in a client machine and i want to port the data
contained in the excel sheet to SQL Server located in a different machine. Can i do this and if so how? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Porting of Excel data to SQL Server 2000 remotely
There are a number of ways to do this, and it pretty much depends on how much
data. Method 1: if there's only a few rows.. and that could be several hundred, then from VBA you could simply use ADO -- connect to the database, then popluate a recordest from the table, pushing it to the database row by row. Method 2: use the SQL server DTS to grab the table from Excel & push it into a table...my preferred way for large amounts of data. "Luke" wrote: I have an excel sheet in a client machine and i want to port the data contained in the excel sheet to SQL Server located in a different machine. Can i do this and if so how? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2000 on Windows Server 2003 | Excel Discussion (Misc queries) | |||
| How to Transfer data from Excel to SQL SERVER 2000 | Excel Discussion (Misc queries) | |||
| Unable Export Data to Excel on Win 2000 Server | Excel Programming | |||
| Excel VBA and SQL Server 2000 UDF | Excel Programming | |||
| Terminal Server 2003 + Excel 2000 | Excel Programming | |||
Linear Mode
