E
Eskimo
Hi all,
I have 23 CSV's in a folder, each with a unique filename. one file
represents a collar from a wild animal that tracks movements.
Anyway, the structure of each csv is this. Rows 1 through 21 is redundant
non-normalized data that I dont need.
What I need is anything below line 22. Line 22 is header info, with 23 down
being the data I need.
What I have done already is linked each of the csv's in the folder to the
database with its own link. Now I am trying to combine each table into one,
but make sure that the records I combine all have a new column indicating
which table it came from.
Any ideas if this is possible?
Thanks,
Eskimo
I have 23 CSV's in a folder, each with a unique filename. one file
represents a collar from a wild animal that tracks movements.
Anyway, the structure of each csv is this. Rows 1 through 21 is redundant
non-normalized data that I dont need.
What I need is anything below line 22. Line 22 is header info, with 23 down
being the data I need.
What I have done already is linked each of the csv's in the folder to the
database with its own link. Now I am trying to combine each table into one,
but make sure that the records I combine all have a new column indicating
which table it came from.
Any ideas if this is possible?
Thanks,
Eskimo