Changes

Access 2000 Data Import Guide

841 bytes added, 22:45, 30 January 2008
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.  
Bureaucrat, administrator
16,192
edits