Results 1 to 12 of 12

[SOLVED] Help with creating multiple text files from query result.

Threaded View

shere [SOLVED] Help with creating... 02-09-2011, 08:41 AM
watersev Re: Help with creating... 02-09-2011, 08:56 AM
shere Re: Help with creating... 02-09-2011, 09:07 AM
watersev Re: Help with creating... 02-09-2011, 10:14 AM
shere Re: Help with creating... 02-09-2011, 10:47 AM
watersev Re: Help with creating... 02-09-2011, 10:54 AM
shere Re: Help with creating... 02-09-2011, 11:09 AM
watersev Re: Help with creating... 02-09-2011, 11:25 AM
shere Re: Help with creating... 02-09-2011, 11:40 AM
watersev Re: Help with creating... 02-09-2011, 11:57 AM
snb Re: Help with creating... 02-09-2011, 11:48 AM
shere Re: Help with creating... 02-09-2011, 02:46 PM
  1. #1
    Registered User
    Join Date
    02-09-2011
    Location
    Warwickshire
    MS-Off Ver
    Excel 2007
    Posts
    6

    [SOLVED] Help with creating multiple text files from query result.

    Hi, I have a spreadsheet for which I need to output the query result to individual sql files. The file name must be based on the name from a cell on the same row.

    i.e

    A___________B
    1 VERSION 1 'EXAMPLE STATEMENT FOR SQL'
    2 VERSION 2 'EXAMPLE STATEMENT FOR SQL'
    3 VERSION 3 'EXAMPLE STATEMENT FOR SQL'
    4 VERSION 4 'EXAMPLE STATEMENT FOR SQL'
    5 VERSION 5 'EXAMPLE STATEMENT FOR SQL'

    In the example above I would like all 5 rows with 5 commands that I need to output to individual sql files. The file names would need to be called what is based on the text in column 'A' for that row followed by a '.sql' extension.

    i.e the output file would be 'VERSION1.sql' for ROW1 which will contain the query result from Column 'B' , Row 1
    Last edited by shere; 02-13-2011 at 09:56 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