Add Record In Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hope this can explain my problem :

Sample extraction from my table

Product Price Cat
Tea 1.50
Coffee 2.00
Choc 3.00

Q. Every mth i will import this data from other system to my Access program
without having the Cat field.

I want to create Cat Field in my Access and want to run an update say for
Tea product Cat will be "A" and Coffee product is "B" & so on without having
to type in manually.

Thanks
 
Hi zyus,

Have a table called ProductCat with fields Product and Cat in it, then when
you perform your import you don't need the Cat, as you can link your imported
data to the ProductCat table to get it. ;-)

Hope this helps.

Damian.
 
Back
Top