Copy and Paste in field names

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

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
 
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/TR?pg=personal&fr_id=1090&px=1434411
 
Back
Top