Creating an EXCEL template to load data into SQL Database

aaron · 07-12-2006

I was wondering whether its possible to create an xls template in excel and allow users to upload that template into the web server and that will automatically fill up the SQL database accordingly..i hope you guys can help me in this..or is there any other solution...<br />kaarthik<br />

Thanks
Aaron

Francisjr · 07-14-2006

Yes, its possible by creating VBA codes on your excel template. The first thing you have to do is create a connection to your database through DSN, then create a command button or event that will make an "INSERT" SQL statements per cell from the excel sheet to your database.

07-12-2006	#1 (permalink)
aaron Junior Member Join Date: Jul 2006 Age: 52 Posts: 24	Creating an EXCEL template to load data into SQL Database I was wondering whether its possible to create an xls template in excel and allow users to upload that template into the web server and that will automatically fill up the SQL database accordingly..i hope you guys can help me in this..or is there any other solution...<br />kaarthik<br /> Thanks Aaron

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
top shows load average is 25%	austin	Site and Server Administration	2	10-12-2006 11:08 AM
Creating pdf files in php	Ankita	PHP	1	10-12-2006 01:45 AM
open existing excel spreadsheet in browser	destiny	Perl	1	07-21-2006 07:57 AM
How To: Make "Export to Excel" always open excel in a separate Window	bradley	.NET	0	07-06-2006 05:32 PM

07-14-2006	#2 (permalink)
Francisjr Member Join Date: Jul 2006 Age: 28 Posts: 61	Yes, its possible by creating VBA codes on your excel template. The first thing you have to do is create a connection to your database through DSN, then create a command button or event that will make an "INSERT" SQL statements per cell from the excel sheet to your database.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

	All times are GMT. The time now is 04:31 AM.
	Contact Us - preCharge.Net - Archive - Privacy Statement - Top