On Jul 2, 12:37 pm, "JoeSpareBedroom" wrote:
wrote in message

oups.com...

Interested in splitting the task? You take half the file and I take the
other? Reassemble it later?

lol . . . that's the way I feel when I'm working on data people send
me at work. If I could just get my hands on them for 5 minutes . . .

I'd be grateful to split the task. I'd also be more than happy to
give you a copy of the entire database at the end if you have any use
for it.

Hang on a sec. If I leave the query as general as possible, I come up with
39,000 to 47,000 plants. How did you end up with 200K?

I downloaded the csv from the USDA. Importing it into Excel, I had to
break it in half. first half around 120k lines. I emailed it to
you. take a look and make sure I counted right. it may be slightly
less than 200k.