Execute SQL SP in Excel VBA
- by TheOCD
HI
I am having problem with getting all the columns back when i execute following code in excel vba. I only get 6 out of 23 columns back.
Connection, command etc works fine (i can see exec command in the SQL Profiler), data headers are created for all 23 columns but i only get data for 6 column.
Side Note: it's not prod level code, have missed…