+ Reply to Thread
Results 1 to 2 of 2

Create Table; Update Table: MS Query

  1. #1

    Create Table; Update Table: MS Query

    I have created an addin that among other things, has the ability to open *.sql files, read the contents of those files into a string variable; then that variable used in MS Query to populate a spreadsheet. It works swimmingly for any select query I have fed to it but action queries return an error. The question is are action queries off limits to MS Query? I will show first the VB I am using. The typical script is too long to post so have attached a text file of a typical script for my purposes.

    Please Login or Register  to view this content.
    Like I said, this works well for select queries. Typically I am going out to a SQL Server database ( I have all permissions necessary for action queries ).

    Attached Files Attached Files

  2. #2
    The answer is the script has multiple scripts, that is Create, Insert, several Updates, and finally Select from the temp table created. While this is acceptable in SQL Server, Excel and Access meager provisions will not allow it -- evidently

    This one script must be broken into various individual scripts - that sucks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Create SQL Query for Pivot Table
    By rbear in forum Excel General
    Replies: 0
    Last Post: 08-13-2008, 03:22 PM
  2. Excel 2007 : Complex query on a pivot table help
    By ZKL in forum Excel General
    Replies: 0
    Last Post: 07-15-2008, 10:26 AM
  3. how do I make Pivot table update automatiocally when I change values
    By soundengineer in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-28-2007, 09:22 PM
  4. How to create Pivot Table and Pivot Chart in VBA
    By aijihz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-20-2007, 01:31 PM
  5. ActiveCell is Query Table or Pivot Table?
    By Air_Cooled_Nut in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-13-2006, 11:07 AM


Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1