i am work in excel it must be save in ms-acess database automatically. please any one help me.?

Answer 1

Convert a Microsoft Excel list to a Microsoft Access database
After you convert a list to Microsoft Access, you maintain the data only in Access. Changes you make to the Access database after the conversion do not affect the Microsoft Excel list.

To convert an Excel list, you must have Access installed. If the Convert to MS Access command does not appear on the Data menu in Excel, you need to install and load the AccessLinks add-in program.

Select a cell in the Excel list.


On the Data menu, click Convert to MS Access.


To create a new Access database for the list, click New database.
To add the list to an existing Access database, click Existing database, and then type the path to the database in the box under Existing database. To look for the database on your system or network, click Browse.

Click OK.
The Access Import Spreadsheet Wizard and Table Analyzer Wizard guide you as you permanently convert your Excel list to an Access database.

Answer 2

Use the Microsoft Access Import Wizard. It can handle Excel file formats or any CSV file format for that matter. It will save the data in a table and you will be able to use it as a regular table within your database.

Answer 3

1.Open your database in MSACCESS
2.select "file" from the menu
3.select "get external data"
4.Select "import data"
then choose MSexcel see that fields are properly arranged in MSexcel the way you want data to be in your database in MSAccess.