How to insert data from MS SQL SERVER to MS Excell sheet?
-
Hi , I am working on some report generation project.Any idea about inserting data from MS SQL SERVER in MS EXCELL Sheet.:rose:
G Singh
-
Hi , I am working on some report generation project.Any idea about inserting data from MS SQL SERVER in MS EXCELL Sheet.:rose:
G Singh
What ideas have you come up with?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
-
Hi , I am working on some report generation project.Any idea about inserting data from MS SQL SERVER in MS EXCELL Sheet.:rose:
G Singh
Not the end solution but it will set you on the right track. Consider using the
OleDbConnectionobject to open the excel spreadsheet. This will then allow you to execute T-SQL commands against spreadsheet as if it were a table.Fernando Mendes Senior .NET Developer, Architect