Hi,
How to populate Tables from Excel files?
I already have a database db file & now I want to import data from the excel file.
Can someone help me with this procedure or can guide me or point me in correct direction?
Thanks in advance.
Hi,
How to populate Tables from Excel files?
I already have a database db file & now I want to import data from the excel file.
Can someone help me with this procedure or can guide me or point me in correct direction?
Thanks in advance.
You can do that easily:
1. Open db you want to enter the data in Excel.
2. Select File from the menu bar.
3. Select External Data from the given menu.
4. Select Import from the submenu.
5. When the Open File dialog box opens select Microsoft Excel (*. xls) from "Files of type" combo box at the bottom of the dialog box.
6. Navigate to the Excel file you want.
7. Highlight it and click the Open button on the dialog box
8. Follow the instructions to complete the import.
Import data from Excel
If this is the first time you are importing data from Excel, you should know the following:
* Do not look for a way to save an Excel worksheet as an Access database. Microsoft Excel does not provide "save as" functionality to create an Access database with Excel data.
* To start the import operation, an Access database must already be open. If you want to import the data into a new database, you must create a blank database (that does not contain any tables, forms, or reports) before starting the importing operation.
* Data that is imported from a worksheet is stored in a new or existing table in the current database. If you are not familiar with tables or how a database is structured, see About tables (MDB) and About designing a database.
* When you open an Excel worksheet in Access (in the File Open dialog box, change the Files of Type list box to Microsoft Office Excel Files, and select the file you want), Access creates a link to the worksheet instead of importing its data. Linking to a worksheet is different from importing a worksheet into a database. For more information about linking, see the section Link to data in Excel, later in this topic.
Getting started with the import operation
1. Make sure the Microsoft Excel data is in list (list: A series of rows that contains related data or a series of rows that you designate to function as a datasheet by using the Create List command.) format: each column has a label in the first row and contains similar facts, and there are no blank rows or columns within the list.
2. Close the Excel workbook that contains the data you want to use in Microsoft Access.
3. In Access, open the database where you want to copy the Excel data.
4. On the Access File menu, point to Get External Data, and then click Import.
5. In the Import dialog box, click Microsoft Excel in the Files of type box.
6. In the Look in list, locate the file you want to import, and then double-click the file.
7. Follow the directions in the Import Spreadsheet Wizard.
For more information about this wizard and Access, click Display Help after the wizard is finished.
Bookmarks