Difference between revisions of "Access 2000 Data Import Guide"
(New page: This is a basic "how to" guide on importing data into Microsoft Access 2000. Category:Computer_Technology Category:Microsoft) |
|||
| Line 1: | Line 1: | ||
This is a basic "how to" guide on importing data into Microsoft Access 2000. | This is a basic "how to" guide on importing data into Microsoft Access 2000. | ||
| + | |||
| + | == Import Excel File Into Access 2000 == | ||
| + | |||
| + | === Create a New Database in Access === | ||
| + | |||
| + | The first step is to create a new, empty database. Unlike a spreadsheet, where you can launch the program and immediately start entering data, in Access you must create an empty database first before you can enter or import data. You can think of this empty database as a container that is going to hold all of your information. We also are unable to simply open an Excel file or any other file directly in Access. We have to import the file into a new or existing database. Once you open Access, depending on which version you are using, either click on New Blank Database in the menu on the right, or go to the File menu and select New Database. | ||
| + | |||
| + | You will be prompted to name your new database file and navigate to a folder for storing it. Microsoft Access databases have the file extension mdb. | ||
| + | |||
| + | Once you create the database you will be presented with the database screen. By default you are in the Tables section, which is naturally blank, as you have not added any data yet. The top of the database window shows the name of the database. | ||
| + | |||
| + | Next to the name of the database is the Access file format version. By default, the version of Access that you are using defaults to the file format used by the previous version, to help insure backward compatibility between your datasets. | ||
| + | |||
| + | === Prepare Excel Data For Import === | ||
| + | |||
| + | === Import Excel Data into Access Database === | ||
| + | |||
| + | |||
Revision as of 10:14, 9 January 2008
This is a basic "how to" guide on importing data into Microsoft Access 2000.
Contents
Import Excel File Into Access 2000
Create a New Database in Access
The first step is to create a new, empty database. Unlike a spreadsheet, where you can launch the program and immediately start entering data, in Access you must create an empty database first before you can enter or import data. You can think of this empty database as a container that is going to hold all of your information. We also are unable to simply open an Excel file or any other file directly in Access. We have to import the file into a new or existing database. Once you open Access, depending on which version you are using, either click on New Blank Database in the menu on the right, or go to the File menu and select New Database.
You will be prompted to name your new database file and navigate to a folder for storing it. Microsoft Access databases have the file extension mdb.
Once you create the database you will be presented with the database screen. By default you are in the Tables section, which is naturally blank, as you have not added any data yet. The top of the database window shows the name of the database.
Next to the name of the database is the Access file format version. By default, the version of Access that you are using defaults to the file format used by the previous version, to help insure backward compatibility between your datasets.
