SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Export excel data to Sql Server
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

dhartikumar
Starting Member

India
1 Posts

Posted - 12/05/2012 :  22:46:51  Show Profile  Reply with Quote
Hi Experts

Required Excel Vba code to export excel data to my sql Server which are in network the server ip is 172.16.10.175.

if any one know please send me the code. dhartikumar@gmail.com

Thanks & Regards


Dhartikumar Sahu
Sr.Manager - Database
IDBI Capital Market Services

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 12/06/2012 :  01:54:18  Show Profile  Reply with Quote
why cant you use OENROWSET?

http://support.microsoft.com/kb/321686

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22769 Posts

Posted - 12/24/2012 :  03:57:16  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

alfredolopez
Starting Member

USA
1 Posts

Posted - 12/29/2012 :  00:11:02  Show Profile  Reply with Quote
Madhivanan, Did you use the OENROWSET, as Visakh16 said? I think it will help you.


http://www.selogerneuf.com/immobilier/tout/immo-lyon-69/

Edited by - alfredolopez on 12/29/2012 00:11:49
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22769 Posts

Posted - 01/02/2013 :  02:09:19  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
quote:
Originally posted by alfredolopez

Madhivanan, Did you use the OENROWSET, as Visakh16 said? I think it will help you.


http://www.selogerneuf.com/immobilier/tout/immo-lyon-69/


Yes. Did you see that link?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2075 Posts

Posted - 01/03/2013 :  08:36:24  Show Profile  Visit jackv's Homepage  Reply with Quote
Another approach is Powershell. Read from Excel and push data into SQL Server. Instantiating the Excel is completed through:
New-Object -ComObject Excel.Application
and then you can use New-Object ('Microsoft.SqlServer.Management.Smo.Server') $instance_name to connnect to the SQL server.

Check this link for an example: http://www.sqlserver-dba.com/2013/01/sql-server-export-excel-data-to-sql-server-with-powershell.html


Jack Vamvas
--------------------
http://www.sqlserver-dba.com

Edited by - jackv on 01/05/2013 10:45:20
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000