Click here to Skip to main content
11,480,031 members (65,002 online)
Rate this: bad
good
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 7:16am
Edited 27-Nov-12 8:13am
ProgramFOX154.4K
v2
Comments
richcb at 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
0 OriginalGriff 235
1 Sergey Alexandrovich Kryukov 215
2 Richard MacCutchan 100
3 F-ES Sitecore 85
4 DamithSL 65
0 Sergey Alexandrovich Kryukov 7,890
1 OriginalGriff 7,556
2 Sascha Lefèvre 3,064
3 Maciej Los 2,491
4 Richard Deeming 2,335


Advertise | Privacy | Mobile
Web01 | 2.8.150520.1 | Last Updated 27 Nov 2012
Copyright © CodeProject, 1999-2015
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