I'm sorry that I don't know SQL that well, so I don't know what the sample SQL provided above will do exactly. While right now I am running an unMatched query I can see that there is a change for the customer somewhere.
Is there any way of being able to generate a report that will highlight the differences of only the fields that have changed? How much more difficult would it be to have a form with data from 2 tables so that I see a pair...
Kevin R
Last Activity: Nov 23 '11, 02:59 PM
Joined: Nov 15 '11
Location:
-
I think it would just be easier option would to see if I could pull the DiskSize, Hard Drive Serial Number, and Hard Drive Model Number through VBS then through a comma after each value when writing to the txt file.
I have figured out how to pull the data for the first 3 lines in my text file (with the commas) and I can have popup prompts for the user to type in the last 3 lines. I just can't find anything on Google to run a straight VB...Leave a comment:
-
Yes SSN is formatted exactly the same in all tables and is in every table.Leave a comment:
-
Automatically creating tables from spacing deliminated fields
I am trying to figure out how to write some sort of code that will go through the txt files in a folder and pull the data into fields plus the txt file name as well.
For example I would like to pull all data after a : or ? plus the file name into a database and then go to the next row in the database and pull the data from the next txt file in that folder.
This is an example layout of one of the files :
...Code:Computername______________________:
-
4. Here is the sample data:
Internal Table
SSN,FirstName,L astName,MiddleI nit,Date,Descri ption,Code
123-456-789,John,Doe,M, 11/16/2011,Pen,Accoun ting
External Table
"Company Code","Formatte d SSN","Formatte d Name","Date","D escription"
"123456","1 23-456-789","DOE, JOHN MIDDLE",2011-11-16 12:00 AM,"P"
...Leave a comment:
-
1. Yes I do have the common field in all tables which are related.
2/3. No, none of the tables have the same number of column fields or rows of customers. While my focus is currently on 2 tables that I am trying to merge there is even another table that will need to flag (or delete) the customer in the single resultant table.
Field names from the seperate company does not match the field names in my company's tables. Also...Leave a comment:
-
Discerning unmatched query from multiple tables
I currently have an unmatched query running for multiple tables, however I would like to view which field(s) are different at a glance.
The background here is that I am trying to create a new database combining data from different departments and a separate company. With so many columns, when there is a typo or conflicting data in only one block I have the entire customer row flagged, resulting in searching for the differences by...
No activity results to display
Leave a comment: