This is a forum where members new and old can come to ask questions and get info and opinions. It is not a place to advertise your business or have other forms of advertising, whether it be in your posts or signature.

All links in the forum will not be indexed by Search Engines and any unapproved forms of advertising or spam will be dealt with accordingly, deleted, and that member's account banned.

Forums

Overview » ASP » Web interface to upload xls file to database

Web interface to upload xls file to database
Greg LeBreck Wicked Member Since: 27 Mar 2003 Posts: 154	Posted 16 Sep 2004 21:23:07 In ASp with a MS SQL backend. I am looking for a how to on allow a user to upload a xls file and have the columns placed into the corresponding fields in a sql table. For example, my user wants to upload a client list to his website. So i give him a xls file or csv file layed out in the same order as the database table. When he fills it in he then goes to the website and uploads it to the database. Thanks! In ASp with a MS SQL backend. I am looking for a how to on allow a user to upload a xls file and have the columns placed into the corresponding fields in a sql table. For example, my user wants to upload a client list to his website. So i give him a xls file or csv file layed out in the same order as the database table. When he fills it in he then goes to the website and uploads it to the database. Thanks!

Web interface to upload xls file to database

Greg LeBreck
Wicked Member

Since: 27 Mar 2003
Posts: 154

Posted 16 Sep 2004 21:23:07

In ASp with a MS SQL backend.
I am looking for a how to on allow a user to upload a xls file and have the columns placed into the corresponding fields in a sql table.

For example, my user wants to upload a client list to his website. So i give him a xls file or csv file layed out in the same order as the database table. When he fills it in he then goes to the website and uploads it to the database.

Thanks!

In ASp with a MS SQL backend.
I am looking for a how to on allow a user to upload a xls file and have the columns placed into the corresponding fields in a sql table.

For example, my user wants to upload a client list to his website. So i give him a xls file or csv file layed out in the same order as the database table. When he fills it in he then goes to the website and uploads it to the database.

Thanks!

Rene Bandsma Total freaking Member Since: 08 Nov 2002 Posts: 419	Replied 17 Sep 2004 21:06:13 I've been working on this earlier this year and have not found a really stable solution yet. But i'm very intereseted in components or pure code

Seb Adlington Freaking Member Since: 09 Aug 2001 Posts: 104	Replied 10 Nov 2004 14:04:30 Hi Guys, I'm looking for a similar solution to import a csv file into an Access table. Had a scout around on the Net and found a good set of postings that look like they might do the job, have yet to try them - will give it a go soon Check out: techies.co.za/phpBB2/viewtopic.php?t=805 If anyone knows a better way, post away CHeers

Reply to this topic

Message
Reply

Live Support

Visit All Zones

Latest Extensions

Premium Articles

DMXzone Updater

Our Sponsors

Find Us on Facebook

Featured Extension

Extensions Yearly Subscription

Tired of purchasing many extensions just to finish up your project. Now we have a solution for you. For a small fee you have access to over 70 high-quality (all DMXzone extensions) and growing Dreamweaver extensions for a year period!

Additionally, we're working on many new ones, which will be available for every subscription holder when released!

Forums

Web interface to upload xls file to database

Reply to this topic

Live Support

On Sale

DMXzone Tabs

Advanced HTML Editor 3

Image Gallery Add-on

File Manager Add-on