Ms-excel 2000 single Record output Sanbang

Excel 2000 itself somehow does not support the output of a single record, and it is a problem if you want to make a single entry in the Address Book in Excel 2000. Come and see how I Sanbang let it come to heel!

One axe: Access transfer method

Can not watch Excel 2000 anxious bar, change a thought, into access inside, let it help me.

Compared to Excel 2000来 said, Access can be considered a database, after all, Excel 2000 name is only "spreadsheet", did not dare to rise too exaggerated. Access can make reports, so you might want to use them. Open Access, click on the "File" menu, "Get External Data", and then select "Import", this is the idiom, as long as the data involved in moving, you may see a similar operation, you have to remember.

Then select Excel 2000 in "File type", check the Excel 2000 address Book file, import, there may be a bunch of options, do not care about it, because our goal is to data, so you can press "finish", but want to know the process of access to import data, May also take a step by step to look, just point "next" can be. Finally, access will naturally receive data from Excel 2000 tables.

The following can be output, the previous said, to borrow "report" one use, so to create a new report to see the pop-up dialog box in the various options, "Label Wizard" is more appropriate (see Figure 1).

Figure 1

Don't forget to choose the following Data source table or query, there is now only one SHEET1 table imported by Excel 2000, OK after the pop-up Label Wizard (Figure 2).

Figure 2

Because the table is imported without its field name, you can see only the field 1, Field 2 "These do not know its name, fortunately, the table is still simple, and we know that in order to choose the right, so there is no harm, but if the table is complex, you have to consider the introduction of the time to do a bit of setup.

With the data, you can also design the label layout, determine the location of variables, in addition to some lines, borders and other modifications, we do not carefully design, because in my opinion, this method is relatively troublesome, I have a better way. The most basic output is as follows (Figure 3).

Figure 3

In any case, it is possible to achieve the goal.