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. 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]]