convert excel spreadsheet to access database

The following code is from blog. csdn. nethellogv. indicate the source for reference! First, this article is intended for friends with database development experience. If you think that your skills are profound or that this article is not helpful to you, don't laugh. The following code is written by the younger brother. Before importing EXCEL data to the database

. Load (drliming, loadoption. overwritechanges, new string [] {"sheet1 "});Datatable dt = Ds. Tables ["sheet1"];If (Dt. Rows. Count> 0){For (INT I = 0; I {// Write database dataString MySQL = "insert into clientinfo values ('" + dt. rows [I] ["name"]. tostring () + "','" + dt. rows [I] ["name"]. tostring ()+ "', '0','" + dt. rows [I] ["Remarks"]. tostring () + "', '0','" + I. tostring () + "')";New dataaccess (). sqlexecute (MySQL );}MessageBox. Show

The following code is from http://blog.csdn.net/hellogv/. for reference, see the source! First, this article is intended for friends with database development experience. If you think that this article is not helpful to you, do not laugh. The following code is written by the younger brother. Before importing Excel data to the database, perform some simple prepar

In the actual development application, the database import export is a common problem, especially the import and export between database and Excel file, and the problem of inconsistent data type. For example: the number of databases in the long time will be formatted in Excel in the scientific notation format, or the r

Import data from Excel into database via access1. Open access, click "EXTERNAL DATA", select Upload "Excel", select the Excel you want to import, click OK.2. Select the sheet to upload the data in Excel, click "Next", click "Next"

I almost have no language, crazy, thought is office itself problem, changed many times office2007, installation and not smooth, changed to office2010, think most should be compatible with 2007, so use office2010.Even almost give up, see a netizen said with SQL to use Excel, is preparing to new contact things. But suddenly I saw my SQL statement and suddenly thought of the "$" sign.Error: Anunhandled exception of type ' System.Data.OleDb.OleDbException

=NewOleDbCommand (SQL, CN); cn. Open (); using(OleDbDataReader drliming =Cmdliming.executereader ()) {ds. Load (drliming, Loadoption.overwritechanges,New string[] {"Sheet1" }); DataTable DT= ds. tables["Sheet1"]; if(dt. Rows.Count >0) { for(inti =0; i ) { //Write database Data