I am importing a new database. I am asked to input field information in MS Access manually. Is there a simpler way? For example, import a cvs version field information into the following
I found how to copy structure only for a access database table:
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.
Maybe this helps.