Multiple linked files in 1 table

  • Thread starter Thread starter Toby
  • Start date Start date
T

Toby

In certain folders I have text files that I link to. Your
mission if you should except, help me figure out how I am
to take all this data from multiple linked files and store
them in one table (for obvious reasons of course). Another
problem is that each file has the same fields, just stores
different data (because the files come from an export of
3rd party software) otherwise I could use a query.
An example of 2 different text files:
File1.txt File2.txt
EmpID, FName, LName EmpID, FName, LName
1, Tom, Jones 1, Joe, Smoe

hopefully that shows you my conflict. Any comments or
suggestions are most welcome.
 
In certain folders I have text files that I link to. Your
mission if you should except,
Click to expand...

Well, I'll accept the mission, but I'll have to take exception to your
text file structure! said:
help me figure out how I am
to take all this data from multiple linked files and store
them in one table (for obvious reasons of course).
Click to expand...

Good on ya! Multiple Append queries, or multiple Update queries, would
seem to be the ticket... but...
Another
problem is that each file has the same fields, just stores
different data (because the files come from an export of
3rd party software) otherwise I could use a query.
An example of 2 different text files:
File1.txt File2.txt
EmpID, FName, LName EmpID, FName, LName
1, Tom, Jones 1, Joe, Smoe

hopefully that shows you my conflict. Any comments or
suggestions are most welcome.
Click to expand...

Well, the conflict in names is obvious - or maybe it's the conflict in
EmpID's. Which (if either) can you trust? Do you want to ignore the
name and import the data associated with an ID (other than the name)
assuming that the IDs in the file are correct, or vice versa? If you
rely on the names in the files, can you be assured that there are not
two people both named Tom Jones (say the part-time night watchman and
the CEO)? And why can't you use a query? (You'll have to do so soon
enough anyway).
 
Back
Top