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
Bookmarks