Importing information into an access template from excel

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?

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/


--

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


"CinCin" wrote in message
...
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?

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
"Ken Snell [MVP]" wrote:

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/


--

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


"CinCin" wrote in message
...
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?

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



"CinCin" wrote in message
...
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
"Ken Snell [MVP]" wrote:

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/


--

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


"CinCin" wrote in message
...
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?