LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
importing data from excel to sql server 2008 by code at run time Ammar S. Mitoori Excel Programming 2 August 13th 09 09:42 AM
importing alphanumeric columns from excel into SQL-Server or MS-Ac herbert Excel Programming 2 May 14th 07 04:39 PM
Problem importing data into sql server database Me Excel Discussion (Misc queries) 1 January 27th 06 01:51 AM
Importing Data from a Stored Procedure (SQL SErver) Martin Eckart Excel Programming 1 January 22nd 04 01:24 AM
Importing data from an Excel file on a web server using ADO/VBA Dean Frazier Excel Programming 0 November 13th 03 12:39 AM


All times are GMT +1. The time now is 10:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"