I need to display information from SQL in Excel quite often. I opened Excel and imported data from Excel while the Excel macro function was enabled. I put this macro in a VB.NET project. The macro is attached.
I keep getting an error on the first line.
Would you give me sample code that imports data from SQL to Excel using .NET Interop?
I need to display information from SQL in Excel quite often. I opened Excel and imported data from Excel while the Excel macro function was enabled. I put this macro in a VB.NET project. The macro is attached.
I keep getting an error on the first line.
Would you give me sample code that imports data from SQL to Excel using .NET Interop?
Thank you
Attachments
Excel importing SQL.txt
Migrated CodePlex Work Item Details
CodePlex Work Item ID: '12613' Vote count: '1'