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
Ms-access – way to input field information by cvs file
importms access
Related Solutions
If you're on *nix - check out the tools sed, awk, grep and split and related (or even vi). As mentioned perl could do it, so could python or PHP (or C or Java or ...) This looks more like a task for programming tools rather than a database. That's not to say you couldn't do this using PL/SQL or T-SQL or , but sometimes the most suitable tool is not within the database server (and in this case, certainly not within MySQL).
You can use Microsoft Access' built-in import features to import data from just about any source.
For Access 2007, the "ribbon" menu has an "External Data" tab, where you can select "Text".
From there it is pretty simple to import text-based data. As you can see from the screenshot, there are a number of other types of data you can import.
Best Answer
I found how to copy structure only for a access database table:
Maybe this helps.
Source:
http://www.techrepublic.com/article/copy-an-existing-table-structure-into-a-new-access-database/