Click here to Skip to main content
12,348,451 members (67,015 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: C#
OK, I have some code and I need to write a list<> of integers onto an xlsx file. But am getting an error.
Here is the code.
string fileName = @"C:\rhandx.xlsx";
 string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" +
          fileName + ";Extended Properties=\"Excel 8.0;HDR=NO;\"";
OleDbConnection con = new System.Data.OleDb.OleDbConnection(connectionString);
con.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = con;
foreach (int coord in rhandlist)
{
    cmd.CommandText = ("INSERT INTO TABLE [SHEET1$] VALUES (coord)");
    cmd.ExecuteNonQuery();
}
con.Close();

rhandlist is a list with unknown no of int's. But I get an error saying my insert statement's syntax is wrong.
Posted 27-Nov-12 6:16am
Edited 27-Nov-12 7:13am
v2
Comments
richcb 27-Nov-12 12:24pm
   
I think you need to remove the word "TABLE" from your insert statment. It should only be the table name.

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

As Richcb pointed out, you need to remove the "TABLE" from your SQL statement. It should look like this:
cmd.CommandText = ("INSERT INTO [SHEET1$] VALUES (coord)");
Make sure you keep the spacing right.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160621.1 | Last Updated 27 Nov 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100