I have a comma separated txt file that contains about 150,000 records that I would like to access through a dnn site. This needs to be searchable and sortable by column if possible. I would also like to make it easy to update with a new .txt file if possible. I'm a complete db dummy, but if any could point me in the right direction I would be very grateful!

 

I have done it in the past with access and the db wizard in front page, but I'm sure there is a much better way.

Can you give us some more information like:

Do each of the uploaded files contain the same columns?
Does any data need to be converted (datetime, different format, lookup values, case, etc)?
Are you hosting the site yourself or is it at an ISP?
Can you create additional SQL tables for your exclusive use?
Should you have an associated batch number with the upload so that you can store multiple copies in the table for later comparison?
If at ISP, will they allow uploading of custom modules?
What type of reports do you need?
How many reports do you need?
Could you compile multiple reports (column sort,filtered) on your local PC and upload the reports to the server for viewing instead of the actual data?

 

It's a genology database. You can see what I need here

 

I have complete control of the server and the associated database so I can create a custom table in it.

 

Multiple copies are not required.

 

The reports required are what you see.

 

Hope that helps

A suggestion.
If you are using MS SQL Server:

Import data using Enterprise Manager to create the table from the file, then modify the column types and length to suit the data being imported. 
You can delete all records and import again using this table to save you modifying it again or create a script of the table and use it to drop table and create a new table.

You can create a local SQL package to automate this -

Open Enterprise Manager, select Data Transformation Services and create local package.

Using this package, you basically tell SQL the file name and it will import it into a table. 
You can set up a job in SQL to import the data.  Part of the package could be a step that checks for a new file.