Importing information into an access template from excel

C

CinCin

I am fairly new to access but have been able to import my excel master
customer list into an access template. It created its own sheet but I want to
put this information into ones that are with the template. Can I not import
it into the ready made ones or does it have to be manually typed or paisted
in?
 
K

Ken Snell [MVP]

ACCESS doesn't contain sheets, it contains tables, so I interpret your post
as noting that the EXCEL data were imported into a new table in the ACCESS
database. You can copy the data from that new table into the template's
table by using an append query.

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/
 
C

CinCin

Thank you Ken. Yes sorry, Table. Can you tell me how to get the append query?
There is a Query Wizard but only give me 4 choices.

Simple query wizard
Crosstab query
Find dulicates query
Find unmatched query

I did the Simple one and choose all the fields in my table that I imported
from excel but it made another one just like the one I imported.
Thank you
 
S

Steve

You did right to use the simple query wizard! Once you have created the
query, while still in design view, click on the Type Of Query Button in the
menu at the top of the screen. There you can change your query to an append
query. Follow the instructions.

Steve
[email protected]
 
Top