Register  |  Login



Question

Status: Closed Points: 100 Time: 11:53 - Sep 05, 2006  

john2

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?

Answer Discussion
Answer Summaries

 

Q&A System for Websites and Corporate Collaboration

Advertisement

  • Generates significant organic traffic for websites
  • Saves companies money, resources, and time

jgivoni

Date:: Oct 08, 2006

Time:: 23:38

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.

john2

Date:: Nov 01, 2006

Time:: 16:44

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.

jgivoni

Date:: Nov 06, 2006

Time:: 02:11

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.

john2

Date:: Feb 10, 2007

Time:: 05:58

Not a problem, anyone else have experience with this?

Question Answered

This question has been closed, 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 the Summary Area.

Answer 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:

Forgot Your Password?

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

Answer 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:

Forgot Your Password?

Ask a Question

Have a new question? Ask!

You have 100 characters to use



Top Databases Experts

View More

Rank

Expert

Points

1.

PeterNZ

325

2.

nidhi

310

3.

LAGM

240

4.

jgivoni

120

5.

xarcus

95

6.

joxley

50

7.

ozzie

50

8.

rcastagna

10

9.

theDude

10

Become an Expert

Register today to share your knowledge with the community and be recognized and rewarded for your contributions.


Register Here




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



Language Options

English:

www.quomon.com

Español:

www.quomon.es