Want to use Excel to do database, use OleDbConnection connection Excel file creation abnormality, on-CodePudding

Want to use Excel to do database, when open the Excel file with OleDbConnection, throw exceptions are: System. Data. The OleDb. OleDbException: "failed to create file,"
Code is based on the c # operation Excel to add and delete instances to write, but I don't know why, as long as the @ "\ ExcelDB XLSX"; To @ "d: \ ExcelDB XLSX"; Will appear this exception, Excel is 07, want see what a great god,

CodePudding user response:

The use of excel in database, and strange people do strange things,

Why don't have the access?

CodePudding user response:

reference 1st floor eaqpi response:

, the use of excel in database, strange people do strange things,

Why don't have the access?

Can I don't have to?

CodePudding user response:

Try not to put in the root directory, or on the code and see it

CodePudding user response:

Permission problems, to d: \ ExcelDB XLSX file to join Everyone permissions

CodePudding user response:

If you write asp.net application, then the data file should be on the site application of the app directory or its directory and should not be on site outside,

CodePudding user response:

refer to the second floor weixin_42374047 response:

Quote: refer to 1st floor eaqpi response:

The use of excel in database, and strange people do strange things,

Why don't have the access?

Can I don't have to?

Why don't you? The customer demand as force majeure, this is the project manager's lazy, should guide customers to adopt a more appropriate solution

CodePudding user response:

refer to 6th floor daixf_csdn response:

Quote: refer to the second floor weixin_42374047 response:

Quote: refer to 1st floor eaqpi response:

The use of excel in database, and strange people do strange things,

Why don't have the access?

Can I don't have to?

Why don't you? The customer demand as force majeure, this is the project manager's lazy, should guide customers to adopt a more appropriate solution

Don't pull it's no use, your so-called customer is my wife, I can guide her, problem solved,

CodePudding user response:

Use SQLite - small database file type, SQLite already unify jiangshan,

Access to those subject to Com components, subject to the x86 x64, after-sales service is a trouble,

CodePudding user response:

Apparently excel is not suitable for used as a database

CodePudding user response:

refer to 7th floor very strange response:

Quote: refer to the sixth floor daixf_csdn response:

Quote: refer to the second floor weixin_42374047 response:

Quote: refer to 1st floor eaqpi response:

The use of excel in database, and strange people do strange things,

Why don't have the access?

Can I don't have to?

Why don't you? The customer demand as force majeure, this is the project manager's lazy, should guide customers to adopt a more appropriate solution

Don't pull it's no use, your so-called customer is my wife, I can guide her, problem solved,

This is very cow force