Using Excel to establish a database Dafa!

【Introduction】
Excel provides some useful feature that allows any one of us can easily get to these databases

Daily work, we often need to create some of regular database. For example, I order to manage the township's agricultural tax, the need to establish a database, which is called the first field name of the village, the second field named groups. I have a total of 19 rural villages, each village, groups ranging from 7 to 17, a total of 258 groups. The database with the database software (even the Visual FoxPro 6.0 or Access97 high grade) are not set up - you enter one by one child, have this idea that only a fool. Access or FoxPro programming with a macro to enter it, the data seems not enough rules (number of groups corresponding to each village is not necessarily the same), this procedure is not so easy to write, unless you are a programming expert and programming fan, or may have suspected the fuss.

In fact, Excel provides some useful feature that allows any one of us can easily get to these databases:

Step one: Open Excel97 (Excel2000 line of course), the cells in column A row 1 insert "name of the village", line 2 insert "East Village", line 19 insert "Village on the back" (Note : Dongshan 17 groups, calculated pursuant to 2 +17 = 19), line 28 insert "Wang Bo Village" (with the previous algorithm, Cattle Village Group 9: 19 +9 = 28), and so on to fill the 19 name of the village good.

Step Two: In line 1 column B put a "group", line 2 insert "Group 1" and press the right mouse button in this select "Copy" Clipboard Copy these three words, then each A name of the village filled with the line of the B column click of a mouse button select "Paste" fill in where a "Group 1."

The third step; with the mouse click on the selected A2 "East Village" cell, and then the bottom right corner the mouse cells (in this case the mouse into a single "Ten" shape), press and hold the mouse down, drag, drag over which automatically fill in the "East Village" is shown. Can use the same method name of the village and the other group with the mouse "a drag is over." Do not worry when you fill group group of Excel will fill all of the "Group 1" as long as you do not take "Group 1" instead of "first group", Excel will automatically recognize it as a sequence for processing. So drag the "Group 1", the complete results as "group 2", "Group 3" ... ... fill out these two fields, other data can continue to fill in Excel, can also be so in the future Fill in database software, anyway, about the labor intensity.

Step Four: Save the file. If you need to create the Access database, so do not ignore it, to use the Excel default ". Xls" format down. If you need to create a FoxPro database, please Dbase 4 (. Dbf) format files.

Step five: If you need the Access database, you must create a new Access database, in the "New Table" dialog box, you select the "Import Table" and then in the Import dialog box, select you just save the ". Xls "file. (What? You can not find?! This dialog box the default file type is Microsoft Access, Microsoft Excel will be able to as long as you have found), selected the import file, you just pay attention to a "first row contains column headings" the box core Tuoxin ㄈ quan  sad suddenly playing Ping Tong D field, you can recommend to you the primary key Access refused - Select "Do not the primary key"), you can ignore the rest, just Click "Next" to completion. After the import is complete you can hit the database to use or modify. If you need a FoxPro database, then the more simple, you can directly save your previous step FoxPro open the ". Dbf" file, according to the need for some, such as field widths, field data type is set to use.

Here, you might say, "Ah, too simple, I will", well, then, I write this purpose is no longer possible to do all the things that a lot of trouble, "when the lazy lazy, "Well.