Importing information into an access template from excel

  • Thread starter Thread starter CinCin
  • Start date Start date
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?
 
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/
 
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
 
Back
Top