View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave[_55_] Dave[_55_] is offline
external usenet poster
 
Posts: 6
Default push recordset from excel to SQL server

Hello,

I've searched but cannot find. There are many posts discussing
populating a spreadsheet from a recordset. I want to do the reverse.

1) select XL data into a recordset (call it "rsxl")
2) insert into an SQL server table the data from "rsxl"

Any help here is appreciated!

Thanks