Very urgent excel reference the relevant fields in the access table

This question uses query and reference statements. It is recommended to copy the data in Access to Excel, which will be more convenient.

You can try vlookup

You can also try it: let's talk about office2000 first, office2003 has not been used, it should be the same as this.

In excel2000, click the data in the toolbar - > to get the external data - > create a new database query, the next step is to select the database in the dialog box - >ms access database, the next step is to select the path and name of the access database in the dialog box, the next step is to select the indication and field name of access in the query wizard, the next step is to filter, the next step is keywords and sorting, and it is done. In this way, the eligible access data can be displayed in Excel and the record can be refreshed.

The approach of Office 2007 is to get the data (-> get external data) - > from the other** - > from Microsoft Query, the others are the same as Office 2000.

Click Data in the toolbar - > Get External Data - > create a new database query, select Database->ms access database in the dialog box that comes out, select the path and name of the access database in the dialog box that comes out, select the indication and field name of access in the query wizard, filter in the next step, keywords and sort in the next step, and complete.

In fact, I personally feel that you can't express yourself clearly.

I have to talk about it a little bit here.

1. About creating forms. Select the table where you want to display the data, then click Insert form, follow the wizard to finish, and then adjust the controls to add aesthetics.

2. The form obtained according to 1 is a bound form, so there is no problem such as reference table records. When set to Unbound or Semi-Bound (unbound is defined as: the data source is empty, and the control is not bound; Semi-binding: unbound data source, bound control, you need to use references.

Unbound reference method: a, as mentioned on the first floor, use dlookup to implement; b. Open the recordset and populate the elements of the recordset to the control. Semi-bound reference methods can be used to update the data source during some events, or to reference unbound reference methods.

3. About entering the VBE interface.

The most common method: select the control right-click on the property (for the form, you only need to right-click on the body and select the form in the drop-down box) event, select "Event Process" to enter the VBE interface (if the dialog box pops up, select the bottom "**" to enter).

For buttons, by default, as long as the button control is added, a dialog box will pop up directly to select, please cancel it and then follow the above method.

Alternatively, you can press Alt+F11 to go directly to the VBE interface, which will enter the module level by default, and then you can select the form on the left (if not, select "Project Explorer" on the VBE view. , then double-click and select Controls and Event Procedures in the "General" and "Declarations" sections on the right (so, if you don't know enough about event processes, it's best to do it the first way).

Field values can be referenced using the dlookup function.