Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft.ACE.OLEDB.12.0 - BUG | Excel Discussion (Misc queries) | |||
OLEDB Help Excel 2002 | Excel Programming | |||
Bug in OLEDB ? | Excel Programming | |||
Create and write a simple text file in Excel/VBA | Excel Programming | |||
EXCEL AND OLEDB | Excel Programming |