I make all my pages in Dreamweaver
That's cause Dreamweaver is da b0mb!
I have Dreamweaver. I'm not saying it's bad or anything but I don't know how to use it
Dreamweaver is a professional website-development tool, which is why it's not recommended for the average user who isn't a moderate to hard-core web designer. The basic features are easy to use, and you can create effective websites with basic knowledge. But the rest of the tools you really got to know what you're doing. Once you learn it, it's an extremely powerful peice of software.
I already have webspace with FP extensions enabled, so that's no problem.
If you have the FP extensions on your web host, then working with an Access database will be fairly simple. In fact, FP has a tutorial about how to us Dynamic Content. Check it out.
I've also inserted both the Excel and Access files into a page on my server, but I can't figure out how to get the info to display correctly.
Excel spreadsheets are best displayed in websites as just plain tables. See, if you used Dreamweaver, you'd find a tool for automatically creating and populating tables from Excel spreadsheets. Since you don't, you'll have to create those tables on your own (if FP doesn't have a help doco on doing such a thing already). Of course, once the files get huge, you'll run into problems, as you've noticed.
If you've got 3000+ entries in your spreadsheet, you really should stop thinking about the spreadsheet and start thinking about only Access (in this case). You'll need to setup a database link between your site and your page (which FP should have a doco on how to do this) and then you can create a page that populates from the database. I forget what all the little FP extensions can do, but if you were running a real setup, you'd most likely use ASP script to populate an automatically generated table for your site.
Bottom line, you'll just have to read the doco and the FP website to figure this out. They have a forum, btw, that's pretty good.