Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft.ACE.OLEDB.12.0 - BUG Sven Pran Excel Discussion (Misc queries) 0 July 8th 08 06:42 PM
OLEDB Help Excel 2002 Brian Belger Excel Programming 1 September 28th 04 08:56 AM
Bug in OLEDB ? Ric[_4_] Excel Programming 4 June 8th 04 11:45 AM
Create and write a simple text file in Excel/VBA Thomas Wieser Excel Programming 4 April 13th 04 10:24 AM
EXCEL AND OLEDB Yama Excel Programming 4 February 25th 04 03:29 PM


All times are GMT +1. The time now is 02:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"