By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,705 Members | 1,891 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,705 IT Pros & Developers. It's quick & easy.

Copy and Paste in field names

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.