By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,680 Members | 1,475 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,680 IT Pros & Developers. It's quick & easy.

Importing partial data to MS Access Table

P: n/a
I have a table in Access which needs updating from an Excel 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!!

Aug 30 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
wi***@beautykat.com wrote in
news:11**********************@m73g2000cwd.googlegr oups.com:
I have a table in Access which needs updating from an Excel
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!!
You want to link to the Excel file instead of importing it, then
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

Aug 31 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.