Re: Importing partial data to MS Access Table
- From: Bob Quintal <rquintal@xxxxxxxxxxxxx>
- Date: 30 Aug 2006 23:14:52 GMT
winzy@xxxxxxxxxxxxx wrote in
news:1156979271.389021.109190@xxxxxxxxxxxxxxxxxxxxxxxxxxxx:
I have a table in Access which needs updating from an ExcelYou want to link to the Excel file instead of importing it, then
file. Instead of importing the whole Excel like a new table in
Acess, how do I do a partial import/update??
For example, Access table has 100 rows of records and 10
columns of attributes. The Excel table has only 50 rows of
records and and 2 attributes. The key IDs for the 50 rows and
names for the 2 attributes are already defined in the Access
table.
Thanks in advance!!
create a query to update the data in Access where the IDs match and
the attributes do not.
--
Bob Quintal
PA is y I've altered my email address.
--
Posted via a free Usenet account from http://www.teranews.com
.
- References:
- Importing partial data to MS Access Table
- From: winzy
- Importing partial data to MS Access Table
- Prev by Date: Importing partial data to MS Access Table
- Next by Date: Summing a Query
- Previous by thread: Importing partial data to MS Access Table
- Next by thread: Summing a Query
- Index(es):
Relevant Pages
|
