Go to Edit> Preferences. Under "Import Options" uncheck "Show import dialogue when memory card is inserted".
Thanks, Andrew. I just started using Lightroom, and it wasn't as obvious to me.
That's ok. It's the first thing I had to do too because it was really bugging me!