The following lines were added (+) and removed (-):
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. Many parts are compatible with most versions of Microsoft Access. Others may be specific to 2000 with minor differences in process. == Copying the Table Structure / Structure and Data / Append Data == To copy the table structure, follow these steps:# Right-click the existing table name in the Database Window of the original database and click Copy.# Close the database Window and open your new database.# Under Objects, click Tables. Then, right-click the database Window and click Paste.# Enter a name for the new table, choose Structure Only, and then click OK. : [[Image:Editing Access Database Import and Export 01.png]] When you open the new table in Design view, it will have the exact same table structure as the original. Now you can now make any changes to the table structure to customize it to fit your needs. 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. You 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.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. You also are unable to simply open an Excel file or any other file directly in Access. Your options are 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.Go to the File menu, and select Get External Data, then Import. Now you must select the file to import. By default, Access is set to import .mdb files, which are other Access databases. Since we want to import an Excel spreadsheet file, change the file type dropdown to Excel. Navigate to the directory where the Excel file is stored and select it. Go to the File menu, and select Get External Data, then Import. Now you must select the file to import. By default, Access is set to import .mdb files, which are other Access databases. Since the goal is to import an Excel spreadsheet file, change the file type dropdown to Excel. Navigate to the directory where the Excel file is stored and select it. <big>* FILE, GET EXTERNAML DATA, IMPORT</big> [[Image:Illustration2008010901.jpg]]