From Access, use Tools / Get External Data / Import. After you select your
spreadsheet file, Access starts a Wizard that lets you identify the
worksheet and columns you want and import them either into a new table or an
existing one.
--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
http://www.deanforamerica.com/site/T...090&px=1434411
"Steve" <sp**@nospam.net> wrote in message
news:S9*****************@newsread1.news.atl.earthl ink.net...
Does anyone know a way to copy and paste or similar a list of fields in an
Excel worksheet into Access to create a table? Example, Sheet1 has this list in
A1 to A7:
CustomerID
FirstName
LastName
Address
City
State
Zipcode
Is there anyway to copy and paste these 7 field names into Access to
create a table of 7 fields with those field names?
Thanks!
Steve