Sending a Insert or Update command to SQL-Server from Excel 
Author Message
 Sending a Insert or Update command to SQL-Server from Excel

Does anyone have an example of the code to send an update or insert to SQL
server from Microsoft Excel.

More specifically - I will have data in 1 or more rows.  I want to write a
macro that will:
(i) if there is data in the first row of the sheet, insert the data into a
given table SQL server and then look to see if there is data in the next
row,
(ii) if there is data in the next row, it insert this in the and then look
to see if there is data in the next row.

The macro will repeat line (ii) until a row without data is found,

Jonathan Palmer
Tel:    + (45) 46 40 95 00



Fri, 29 Oct 1999 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Problem with Insert command statement and updating SqlServer

2. Inserting Data from SQL Server into MsgText when sending reply

3. VB 3.0 with SQL SERVER 7.0 (Update, delete and Insert)

4. VB 3.0 with SQL SERVER 7.0 (Update, delete and Insert)

5. Updating SQL server from an Excel sheet

6. Inserting data into mutliple tables using SQL Insert Command

7. Insert Data Into Access Database From SQL Server ADO Insert

8. need ID from newly inserted record (altered by insert trigger on SQL server)

9. Insert date type varible through ODBC SQL server driver to SQL 7.0 database

10. 2nd SQL Server update after update text field corrupts row - using RDO

11. Command Button to Send as Attachment and Insert Subject

12. Command Button to Send as Attachment and Insert Subject

 

 
Powered by phpBB® Forum Software