+ Reply to Thread
Results 1 to 3 of 3

Excel with SQL Server

  1. 03-10-2016, 01:15 AM #1
    vini1508 is offline
    Registered User
    Join Date
    02-08-2016
    Location
    Maharashtra
    MS-Off Ver
    Office 2010
    Posts
    11

    Unhappy Excel with SQL Server

    hiii,, i want to know can we connect to Sql Server through Vba for inserting data into Sql pls help.. i want to store my excel data into database to generate reports from them... is it possible through vba.. pls guide me..
    Reply With QuoteRegister To Reply
  2. 03-10-2016, 01:29 AM #2
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,378

    Re: Excel with SQL Server

    Hi vini,

    I know Excel can pull SQL data into Excel for reports. I'm not sure if you can write out to the SQL data using Excel, but I do believe you can with Microsoft Access. In Access you can LINK to the SQL and therefore write to it as well as pull from it.

    See https://www.simple-talk.com/sql/ssis...eps-to-follow/
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.
    Reply With QuoteRegister To Reply
  3. 03-10-2016, 02:55 AM #3
    vini1508 is offline
    Registered User
    Join Date
    02-08-2016
    Location
    Maharashtra
    MS-Off Ver
    Office 2010
    Posts
    11

    Re: Excel with SQL Server

    in the link u give me they are perfoming task using Visual Studio but I'm creating a macro(add-in) in which i want to connect to the Sql Management Studio and perform actions like Insert, Update, Delete,etc.. Is it Possible
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Populate Server Function based on Server Name for Server Inventory
    By mvcp007 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-13-2013, 11:29 AM
  2. How may I open in Excel Mac 2004 an Excel 2010 sheet that is located on a server?
    By Alooha in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-23-2011, 09:30 AM
  3. Disable "Cannot locate Internet server or proxy server" message
    By spygatau in forum Excel General
    Replies: 1
    Last Post: 11-12-2010, 05:57 AM
  4. Excel Hyperlink gives error cannot find internet server or proxy server
    By athens61 in forum Excel General
    Replies: 1
    Last Post: 04-26-2007, 10:36 PM
  5. Excel Hyperlink gives error cannot find internet server or proxy server
    By athens61 in forum Excel General
    Replies: 1
    Last Post: 04-26-2007, 10:24 PM
  6. Excel 2003 Error Cannot Locate the Internet Server or Proxy Server
    By Seabee in forum Excel General
    Replies: 0
    Last Post: 11-19-2005, 08:10 PM
  7. EXCEL err msg: cannot locate internet server or proxy server:hyper
    By Debby in forum Excel General
    Replies: 1
    Last Post: 07-16-2005, 08:05 AM
  8. problem updating link from Novell server to windows server #REF er
    By Ellen in forum Excel General
    Replies: 0
    Last Post: 05-10-2005, 05:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1