Field Names

[Guest]

I have a list of 140 field names in an excel worksheet that I would like to
use in a new table. Is there a way to create the table and name those fields
without linking it and typing the name of each new field?

Thanks

 

[Guest]

You can import it by clicking on menu FILE - Get External Data - Import.

BUT - that many fields does not sound like a normalized relational database.

 

[John W. Vinson]

I have a list of 140 field names in an excel worksheet that I would like to
use in a new table. Is there a way to create the table and name those fields
without linking it and typing the name of each new field?

Thanks

File... Get External Data... Import, and select Excel from "files of type".
You can import the entire table, or I believe you can import design view only,
which will create an empty table with the fieldnames.

Note that 140 fields is fine as a spreadsheet but is DREADFULLY non-normalized
as a Table. You'll almost surely want to restructure the data into multiple
Tables if you'll be using it in Access.

John W. Vinson [MVP]