ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> Access General Issues >> update query problem
http://www.istechforum.com/YaBB.pl?num=1167962132

Message started by HB on 01/04/07 at 17:55:32

Title: update query problem
Post by HB on 01/04/07 at 17:55:32

I created and update query that allows me to take contract prices that I have in an xls spreadsheet and put them into BKICPMAT. It works fine except for every row in the spreadsheet it creats 20 or more entries in the BKICPMAT database. I created linked tables of the xls spreadsheet and of the BICPMAT database.

When creating the BKICPMAT link, I am asked to identify a unique file name, but of course there is none, since CustID and ProdID can be present multiple times.

Does anybody know, how to avoid these duplicates?

Title: Re: update query problem
Post by Kelloggs on 01/15/07 at 07:10:34

Did you fix the problem?

Regards,

Kelloggs

Title: Re: update query problem
Post by HB on 01/17/07 at 15:08:30

No,
the problem is not solved.