Create and write XLS using OleDB
I have an ArrayList of string[] objects that I just want to dump to a Excel spreadsheet. All the string[] objects are the exact same length, no null values. How do I create an Excel file without Interop? I'm trying objCmd.CommandText = "Insert into [Sheet1$] values('a','b')"; after I manually create a file.. and sometimes that has worked an sometimes it will tell me "number of query values and destinatio fields are not the same". I don't use column names. I just want to dump the values. Any ideas -- sporadicPosted from http://www.pcreview.co.uk/ newsgroup acces |
All times are GMT +1. The time now is 10:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com