Results 1 to 4 of 4

Use .txt file instead of SQL Query

Threaded View

mark_jam3s Use .txt file instead of SQL... 09-09-2010, 09:32 AM
JBeaucaire Re: Use .txt file instead of... 09-09-2010, 10:38 AM
romperstomper Re: Use .txt file instead of... 09-09-2010, 10:45 AM
mark_jam3s Re: Use .txt file instead of... 09-17-2010, 10:03 AM
  1. #1
    Registered User
    Join Date
    06-12-2008
    Posts
    11

    Use .txt file instead of SQL Query

    I've created a basic macro that pulls data from SQL sever into excel.

    The connection string and and query work fine but I was wondering if it is possible to replace the query embedded within the macro to call a .txt or .sql file and use the text within the file as the query?

    so instead of .Open "SELECT * FROM Authors" I would have a link to the text file and use the text contained within it as the query

    Any help or pointers in the right direction will be much appreciated.
    Last edited by mark_jam3s; 09-17-2010 at 10:06 AM.

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1