W
WillZimm
I need to create a macro that allows me to import multiple files as tables.
The idea is to get files that are named after days, IE 04292008.csv,
04302008.csv, . . . and to compare them to each other to count the number of
records in the individual files and to find duplicate lines that differ by
only one field, a date, and to report back the first field and the dates that
have a duplicate entry. Just as a warning, I am a quick learner, but new to
access, and bordering on actually knowing a little bit.
The idea is to get files that are named after days, IE 04292008.csv,
04302008.csv, . . . and to compare them to each other to count the number of
records in the individual files and to find duplicate lines that differ by
only one field, a date, and to report back the first field and the dates that
have a duplicate entry. Just as a warning, I am a quick learner, but new to
access, and bordering on actually knowing a little bit.