2
Answers

Excel error The INSERT INTO statement contains the following unknown field name: '23#143214'

Ask a question
worldisflat

worldisflat

13y
10.1k
1
Hi,

I have an excel file that I can succesfully write to with the ado jet driver in c#.  The problem seems to occur when I write doubles (or mixing and matching possibly):

	insertAt(2, 2, "test",myConnection);
        insertAt(3, 2, "test2", myConnection);
        insertAt(4, 2, "23", myConnection);
        insertAt(5, 2, "23.143214", myConnection);
        insertAt(6, 2, "276.0133", myConnection);

This results in following SQL command (on the line it crashes):
"INSERT INTO [pFACTData$B6:B6] Values ('276.0133')"
The error message is talking about hashes though for some reason

The INSERT INTO statement contains the following unknown field name: '23#143214'.  Make sure you have typed the name correctly, and try the operation again.

It's like the command is corrupted somehow after it is sent.  Anyone know why this doesn't work?

Answers (2)