View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ramszone ramszone is offline
external usenet poster
 
Posts: 1
Default Importing Excel data with macros to SQL server

Hi All,

I need to import an excel sheet data to sql server.
I have imported each sheet in excel sheet into a table in sql server and I
have made a proper relation between tables.
I found a function written in vb, that updates the cells when I click on a
button on the sheet.
I need to convert this code into a stored procedure or function in sql
server.
Can anyone please help me how to achieve this?

Thanks in advance,
Rams.