VB.net use Excel when the database, including t1 to Excel in the first lines of a field

TSQL="insert into [Sheet1 $] (t1) values (' 123 ')"

Always prompt error: System. Data. The OleDb. OleDbException: "operation must use an updateable query,"

Just tried the Access database, use the following SQL by
TSQL="insert into table 1 (t2) values (' ss ')"

CodePudding user response:

EXCEL and ACCESS,


[Sheet1 $] the name of the problem may be,

CodePudding user response:

The

reference 1 floor XBodhi. Response:

EXCEL and ACCESS,


[Sheet1 $] the name of the problem may be,

But with the select * from [Sheet1 $] can be used and queries to the results,

CodePudding user response:

Done, is the connection string IMEX=1 to IMEX=0, IMEX=2

CodePudding user response:

https://www.cnblogs.com/goto/archive/2012/04/12/2443670.html

The inside