Importing only one field from a table

[Lasse T]

Hello !!

I have a table with items and prices. When a new price list comes out I want
to import only the price from each post and not the whole post. That is
becaurce I have fields in my table that dont exists in the pricelist.
I can not find out how to do that. I import the pricelist from Excel to a
new table called import. Then I have a query that imports to my table but
now only the new posts are imported becaurce of the index that dont allow
duplicates. This is ok. I only want the new ones but as I said, I also want
the old prices to be updated. I have an unique number in bouth the tables so
it should work if I only knew how to do it.

Thanks in advance.

Lasse T
-----------

 

[Douglas J. Steele]

See whether the approach outlined in http://support.microsoft.com/?id=127977
helps.

Don't worry that it only states Access 2.0, Access 95 and Access 97: it
applies equally to all versions of Access.

 

[Lasse T]

Thank You.
It works just fine.

Lasse T
--------------

See whether the approach outlined in http://support.microsoft.com/?id=127977
helps.

Don't worry that it only states Access 2.0, Access 95 and Access 97: it
applies equally to all versions of Access.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

Hello !!

I have a table with items and prices. When a new price list comes out I want
to import only the price from each post and not the whole post. That is
becaurce I have fields in my table that dont exists in the pricelist.
I can not find out how to do that. I import the pricelist from Excel to a
new table called import. Then I have a query that imports to my table but
now only the new posts are imported becaurce of the index that dont allow
duplicates. This is ok. I only want the new ones but as I said, I also want
the old prices to be updated. I have an unique number in bouth the

tables