Wrox Programmer Forums
Classic ASP Professional For advanced coder questions in ASP 3. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old September 13th, 2006, 10:58 AM
Authorized User
Join Date: Jan 2005
Posts: 46
Thanks: 0
Thanked 0 Times in 0 Posts
Default Bulk upload of data


I am writing an ASP application, which requires a database containing a table of users. Each user has a last name, a first name, a username and a password. Each user can be added individually via my application. However, I want to be able to upload multiple users (say, about 100 at a time) using data held in a spreadsheet. i.e. I want to bypass my web application form, and upload the spreadsheet via a different form, and have the application grab that data and enter it into the database automatically.

Please can you advise on how I can do this?


Old September 13th, 2006, 01:15 PM
Wrox Author
Join Date: Oct 2005
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons

Read from your spread sheet like a database and just pass the information into the database.


"The one language all programmers understand is profanity."
Old September 15th, 2006, 12:59 AM
Authorized User
Join Date: May 2006
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts

Just posted this in ASP Components..


Same same but different..

Hasta Luego..

DogFightClothing. No dogs. No fighting.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Bulk insertion from a data table to oracle databas Alexkure ASP.NET 1.0 and 1.1 Professional 0 November 12th, 2008 03:24 AM
How to insert bulk of data through form in databas ashuphp Beginning PHP 1 April 11th, 2007 07:36 AM
Upload file and data Dj Kat Classic ASP Basics 2 April 11th, 2006 05:56 AM
How to pass bulk data(dataset) between webpages jaisonkmathews ADO.NET 10 October 3rd, 2004 02:08 PM
How to pass bulk data(dataset) between webpages jaisonkmathews General .NET 4 September 17th, 2004 09:29 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.