On Wed, 8 Jul 2009 14:49:02 -0700, MaryJC
wrote:

I have an Excel file with a long list of variable names I want to use to
create a table in Access. Is there somewhere I can paste them into the table
design all at once so I don't have to type or paste them in individually?

You can open Access and use File... Get External Data... and either Import or
Link to the spreadsheet. Choose Excel from the "files of type" dropdown.
--

John W. Vinson [MVP]