Add data from Excel to Access

[Chandai]

I would like assistance with adding to table without having to type every
record. I have data that's exactly the same in Excel and would like to
import them into one table. I am familiar with importing data from Excel to
Access. I don't know how to get additional Excel info added to the existing
table.

Thank You.

 

[Jeff Boyce]

Chandai

Take a look at the Append query...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Chandai]

I know how to create a simple query with table already in Access. I looked
at the instructions to create an append query but the problem I have is that
I have the data in Excel. Please advise if I have to import all the Excel
into Access and create tables before I can do the append query. The show
table shows on design view the table I imported. Thank You.

 

[Jeff Boyce]

It isn't necessary to import the data into Access (i.e., make a copy of the
data and place it in Access).

Instead, you can "link" to the Excel file (how depends on which version of
Access - check Access HELP for "linked tables").

Once you have the data 'linked', just create your query against that data.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John Spencer]

If you already have the existing table, you can import into an existing
table. It is one of the options when setting up the import. When you
import into an existing table, records are ADDED to the records that are
already in the table.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================