Thanks for the quick response.
In answer to your questions:
1. I will be coping the three columns mentioned plus other data. If all three match I will ignore, if not I will use the PartNo. to query a database to place data in sheet 3. So in reality I am looking for a true/false in the compare...
Through a another process I assemble an Excel worksheet(1) with data in three columns:
PartNo. DwgRev PLRev
In another worksheet(2) I have the same three columns as well as other data.
What I need to do is start with the "PartNo." in Sheet(1), find if it exists in the other...
I have a peer to peer network with a mixture of ME & XP machines. Recently moved office and changed to DSL, added switch & router. What seems to happen is when the XP machines are put on line they flood the network to the point of excluding anyones access to the internet. Connection status on...
I have a peer to peer network with a mixture of ME & XP machines. Recently moved office and changed to DSL, added switch & router. What seems to happen is when the XP machines are put on line they flood the network to the point of excluding anyones access to the internet. Connection status on...
I may have mispoke. From my working table I will most likey have to both update and append. Somehow I need to test if record exists, if so update. If record doesn't exist I will need to add. I am looking for an approach.
I have a database where I extract data from two sources, merge the data for use by another program. The merged data is stored in a "working" table. I then need to either append or update another table for export. This table has a double key. I am looking for an easy way to update those...
I have an application where I need to export a "^" delimited text file for use in another program. The problem is one of the fields is numeric and the output text file has small numbers converted to scientific notation. I have tried changing field lengths, converting the field type to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.