Changes

Access 2000 Data Import Guide

1,458 bytes added, 16:14, 9 January 2008
The following lines were added (+) and removed (-):
== 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 ===
Bureaucrat, administrator
16,192
edits