Register  |  Login

Question Details    

   Question

Time: 11:53 - Sep 05, 2006     Asked by: john2      Status: Answered      Points: 100   

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?

Ask a New Question

Become a Quomon Expert

Current Categories

 

Other Questions Needing Answers


   

Answer Discussion
Answer Discussion
Answer Summaries
Answer Summary
 
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.

Expert:

jgivoni

Date:

Oct 08, 2006

Time:

23:38

 

Votes: Good (0) | Bad (0)
Login to rate this answer

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.

Expert:

john2

Date:

Nov 01, 2006

Time:

16:44

 

Votes: Good (0) | Bad (0)
Login to rate this answer

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.

Expert:

jgivoni

Date:

Nov 06, 2006

Time:

02:11

 

Votes: Good (0) | Bad (0)
Login to rate this answer

Not a problem, anyone else have experience with this?

Expert:

john2

Date:

Feb 10, 2007

Time:

05:58

 

Votes: Good (0) | Bad (0)
Login to rate this answer

Question Answered

This question has been answered, and points have been rewarded to the following experts:

jgivoni: 100

You're welcome however to comment or give additional information or if you wish, you have the ability to write an Answer Summary for this question by clicking on the "Answer Summaries" Tab.

 
No summaries have been submitted yet. Want to be the first?



Respond to this question:

New User

  Email:

Upon submission of this form, you will automatically be registered as a Quomon user and we will send your login information to this address

Registered User

Username:

Password:


Forgotten Password

 

New User

  Email:

Upon submission of this form, you will automatically be registered as a Quomon user and we will send your login information to this address

Registered User

Username:

Password:


Forgotten Password

   

"Psst, Quomon is a great site. Pass it on."     Tell a Friend  |   Link To Us  |   Save to Delicious  |   Digg! Digg it


All Questions


Language Options

English:

www.quomon.com

Español:

www.quomon.es

Quomon Blog

blog.quomon.com

Sponsors

Questions and Answers Software
Real Estate Postcards
Marketing Fulfillment