I have a table called LP that has name, address, phone and some other types of information. Periodically I receive a delimited text file that has all current information. I don't want to replace the original table because I want to keep info that may be in a memo or other field that I have added and I want to retain any entries that may no longer be active and therefore no longer included in the new info. I can easily find new entries to add to the LP table using an unmatched query, but is there a way that I can find if a manager name or phone number or some other piece of information has simply changed so that I can make the appropriate updates? Thanks in advance.
5 2094 ADezii 8,834
Recognized Expert Expert
I have a table called LP that has name, address, phone and some other types of information. Periodically I receive a delimited text file that has all current information. I don't want to replace the original table because I want to keep info that may be in a memo or other field that I have added and I want to retain any entries that may no longer be active and therefore no longer included in the new info. I can easily find new entries to add to the LP table using an unmatched query, but is there a way that I can find if a manager name or phone number or some other piece of information has simply changed so that I can make the appropriate updates? Thanks in advance.
Is there a common, Primary Key Field, in both the Delimited Text File and LP Table that uniquely identifies an individual, such as a Social Security Number?
Yes, a license number field does. (Sorry for the delay in response, I've been out of town.)
ADezii 8,834
Recognized Expert Expert
Yes, a license number field does. (Sorry for the delay in response, I've been out of town.)
Don't feel bad, I'm on Vacation myself and was only able to get to this PC for a short interval. Since the [license number] Field uniquely identifies an individual in both the Delimited Text File and the LP Table, this should be a cake walk for you. Follow these instructions, and you should be OK: - Import the Delimited Text File data and for the sake of Argument, lets call it Table1.
- Delete any Records that have no value in the [license number] Field, since they will be of no use to you.
- Make the [license number] Field in Table1 the Primary Key for the Table (reason for prior deletions).
- Make sure it is the same Data Type as the [license number] field in your LP Table.
- Create a Query, then add Table1 and your LP Table to the Query Grid.
- Create a Join on the [license number] Field in Table1 to the [license number] Field in the LP Table. It will look like this: Table1.[license number](1) ==> [LP Table].[license number](M).
- Drop down any Fields you want into the Query Grid.
- Now that the Join exists between these 2 Tables you can easily verify any individuals whose specifrc data has changed for instance: if you want to see if an Employee's Address has change, drop the [Address] Fields from both Tables into the Query Grid and set the Criteria for the [Address] Field in Table1 to <> [LP Table].[Address].
- Good luck. I don't know if I'll be able to get to a PC again, so if you have any other questions, I'm sure one of the Moderators/Experts will pick it up.
That worked like a dream. Thanks so much!
ADezii 8,834
Recognized Expert Expert
That worked like a dream. Thanks so much!
Any time, CindySue. We are always glad to assist anyone here at TheScripts.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Xah Lee |
last post by:
suppose you want to do find & replace of string of all files in a
directory.
here's the code:
©# -*- coding: utf-8 -*-
©# Python
©
©import os,sys
©
©mydir= '/Users/t/web'
|
by: rbt |
last post by:
Here's the scenario:
You have many hundred gigabytes of data... possible even a terabyte or
two. Within this data, you have private, sensitive information (US
social security numbers) about your...
|
by: suzy |
last post by:
Hello,
I am trying to write a generic tool that accesses a SQL server and
reads/updates/deletes/creates records. I want to reference this tool from
my asp.net pages to talk to my db. by the...
|
by: Roger |
last post by:
I have a datagrid and would like to know what even fires when a cell is
changed?
I want to know when the user changes a cell and moves to the next. I have
some code that needs to be done to...
|
by: one man army |
last post by:
Hi All-
I am new to PHP. I found FAQTS and the php manual. I am trying this
sequence, but getting 'no zip string found:'... PHP Version 4.4.0
$doc = new DomDocument;
$res =...
| |
by: SunnyDrake |
last post by:
HI!
I wrting some program part of it is XML config parser which contains
some commands(for flexibility of engenie).
how do i more simple(if it possible not via System.Reflection or...
|
by: dave |
last post by:
Hi,
I have searched for the answer for this error message without
success. I have seen the question many times though:)
I create an ASP.NET project (VS 2005, C#), and use a very simple .mdf...
|
by: nimjerry |
last post by:
i am using db2 udb V 9 on aix 5.3 and in db2diag.log alwas has this error occurr
below is sample message
2008-03-03-09.45.34.366406+420 I306667A443 LEVEL: Warning
PID : 835622 ...
|
by: Slippy27 |
last post by:
I'm trying to modify a find/replace script which iterates through a file A and makes replacements defined in a csv file B. My original goal was to change any line in file A containing a search string...
|
by: sh.vipin |
last post by:
is there any way to find out number of bytes freed on a particular
free() call in C
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |