RE: $$Excel-Macros$$ Extracting data from SQL server to Excel using macro

2011-07-03 Thread Rajan_Verma
Data from Selected Table, From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Markkim Sent: Saturday, July 02, 2011 9:09 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Extracting data from SQL server to Excel using macro Hi I know a b

Re: $$Excel-Macros$$ Extracting data from SQL server to Excel using macro

2011-07-02 Thread ashish koul
try this http://www.ozgrid.com/forum/showthread.php?t=83016&page=1 On Sat, Jul 2, 2011 at 9:09 PM, Markkim wrote: > Hi > > I know a bit of SQL.. can write a bit of complicated query.. > > At work, I don't have Write right to SQL server.. because my role is to > investigate and report. > > I

$$Excel-Macros$$ Extracting data from SQL server to Excel using macro

2011-07-02 Thread Markkim
Hi I know a bit of SQL.. can write a bit of complicated query.. At work, I don't have Write right to SQL server.. because my role is to investigate and report. I would create a stored procedure and simply bring records I want using 'From other source' in Data tab. But that's not possib