How do I upload and count different database files in ASP?
I need to build an application that allows my users to upload an excel database and count the records in that database so I know how much to charge them. I also want to give them the ability to upload their database as a text file (tab or comma delimited) and have the program count those files also. Anyone know how this would be accomplished or know of any online tutorials for such an application?
Status:
Open Sep 05, 2006 - 08:53 AM
Databases, asp, text delimited, uploading files, mailing list, excel
4answers
Answers
Oct 08, 2006 - 08:38 PM
I don't know what an Excel database is... Do you mean Access database?
If it is an Access database, you can connect to it in ASP (if you know the location) and count the rows in a table.
There are probably numerous tutorials on this,
If it's a comma delimited file, you can open it in ASP and count the newline characters which delimits the records.
Nov 01, 2006 - 12:44 PM
No, I mean excel. It is a mailing list, database was the wrong word. A mailing list will all different columns representing the different fields like Address, First name, last name, city, state, zip, etc. We receive excel lists and lists in text delimited formats so I wanted to know if there was any online resources for doing that.
Nov 05, 2006 - 10:11 PM
Ok, I see. I guess I was hoping you didn't really mean Excel, since I have no clue how to do that :-)
I think I would convert and save it to comma separated file which can be opened in an ASP script. Should be fairly simple to count the number of lines then. Sorry I don't have the documentation right here with me.
Feb 10, 2007 - 01:58 AM
Not a problem, anyone else have experience with this?
Answer this question
Share Your Own Experience & Expertise
We look to ensure that every question is answered by the best people with relevant expertise and experience, the best answers include multiple perspectives. Do you have relevant expertise or experience to contribute your answer to any of these commonly asked questions?
Add New Comment