Do you want to be able to visually browse the files ?
Savig a DTS package makes it drop dead easy to run file imports from CSV/Excel and similar file types and will create the destination table(s) if they don't already exist or you can manually name them and whatnot. You probably know this already.
The crucial point here is where you say you want to be able to browse those files though.
Can you confirm what you mean and how much information you want to be able to get from them when you browse them. You can get dedivcated CSV file browsers for archives of files of that type, and each archived folder has an indexed document with the file details in the archive folder listed for quick search. It's along the lines of an ASCII searchable file/folder system.
I'll be back later on and will look in on this to see if you've gained any ground on it.