Results 1 to 6 of 6

Insert an Excel range to SQL Server using ADO (push from Excel)

Threaded View

  1. 08-04-2014, 09:43 PM #4
    treva26
    treva26 is offline
    Forum Contributor
    Join Date
    06-12-2007
    Posts
    144

    Re: Insert an Excel range to SQL Server using ADO

    I do have a dollar sign after the sheet name:

    [Forecast$A2:AS10]
    I think the issue is that form of code is for running on the SQL server and referencing an Excel sheet.

    I am running vba code in Excel. So I probably need something quite different.
    An array object or something?
    Last edited by treva26; 08-04-2014 at 11:15 PM.
    Reply With QuoteRegister To Reply
« 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. 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
  3. 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
  4. [SOLVED] 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
  5. [SOLVED] 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

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