How do I save the data of a form to the ACCESS database?

set conn="")

dbpath="The relative path of the database")

set rs="")

rs("Name")="name")

rs("**")="tel")

Method steps.

The conversion between Excel sheet data and access is mainly achieved through macros. First of all, open the database, find "Create-Macro" in the toolbar, click the macro, and the interface in Figure 2 will appear.

To create an Excel sheet data import macro, click "Design - Show All Operations" in the toolbar, click the macro selection menu (Figure 2 below), and select "TransferSpreadsheet".

Data import settings (Figure 3 below):

1. Select Import as migration type

2. Select "Microsoft Excel 97 - Excel 2003 Workbook" as the electronic type

3. Table name: If you want to enter the existing table in access, enter the name of the existing table, and if you want to create a new table, enter the name of the new table, and a new table will be automatically generated after importing.

4. File name: that is, the full path and form name of the excel sheet you need to import.

5. Select "Yes" with the field name.

6. The scope can not be selected.

After the settings are complete, click the save icon in the upper left corner, enter the name of the macro you have defined, and then "Confirm", and the macro imported by Excel will be created (Figure 2 below). If it is run, double-click with the left mouse button to import the data into the desired table or automatically generate a new table (Figure 3 below).

Create an Excel sheet data export macro: The steps are basically the same as the second step, select "TransferSpreadsheet", but there is a slight difference in the export settings.

Data import settings (below):

1. Select Export as migration type

2. Select "Microsoft Excel 97 - Excel 2003 Workbook" as the electronic type

3. Table Name: refers to the name of the table to be exported in the access database.

4. File name: refers to the complete path and table name exported from the database to the target excel sheet.

5. Select "Yes" with the field name.

6. The scope can not be selected.

Save and run as in step 3.

Create an action panel: Database Tools - Toggle Panel Manager in the toolbar.

Panel Manager Settings:

1. Select "Main Switch Panel" and click (Figure 1 below);

2. Click "New" to appear (Figure 3) on the interface "Switch Panel Project";

1. Text: It is the name of the project you need to create, such as setting the name to "production report import";

2. Command: The way of the form in the database, select "Run Macro";

3. Macro: Select the macro that needs to be run, as mentioned above, the macro "Production Report Import" that has been created above;

4. Press "OK" to complete the setting.

5. Follow the above steps to complete the panel settings of "Production Report Export".

6. Close the database panel settings: select "New" - the text is named "Close Database" - command to select "Exit Application" - "OK" (as shown in Figure 4 below).

4. Select the "Close" button, and the panel setting is completed.

I hope you found this article helpful.

Open Excel and select From Access in Data to export tables and queries in Access.