DaniWeb IT Discussion Community

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)
-   ASP (http://www.daniweb.com/forums/forum62.html)
-   -   Import excel records into ASP database (http://www.daniweb.com/forums/thread21987.html)

Cadde Apr 16th, 2005 5:28 am
Import excel records into ASP database
 
Would you please send me a code for importing records in an Excel worksheet into my Asp Application database.

Your earliest response is higly appreciated. Thanking you in advance.

william_stam Apr 23rd, 2005 4:27 am
Re: Import excel records into ASP database
 
does this need to be done regularly or is it a once off? if it is once off then what you could do is create a csv (comma deliminated doc) and import it into your database. i am not too sure if it is possible to get asp to do it automaticaly.

jpn311 Apr 26th, 2005 1:01 pm
Re: Import excel records into ASP database
 
Your best option is always to use the built in import/export functionality that already exists and nearly all database systems. If for some odd reason this is not an option for you, you can connect to an Excel spreadsheet and read the rows of data just like you would any other database. Your DSN-less conenction string would be similar to :

"Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=" & Server.mappath("./YourSheet.xls") & ";UID=admin;"

Just loop through the recordset, grab the values, then insert them into another db.

william_stam Apr 26th, 2005 5:15 pm
Re: Import excel records into ASP database
 
i thought about it, makes sense if the excel doc is in proper format. no cell merges. the excel document would have to be uploaded to the server first, also the server would need to have the excel driver installed (don't think it is preintalled????

jpn311 Apr 26th, 2005 5:21 pm
Re: Import excel records into ASP database
 
The Excel driver is installed as part of MDAC, which should come pre-loaded on all Windows servers.

william_stam Apr 26th, 2005 5:30 pm
Re: Import excel records into ASP database
 
that was fast. ok sorry wasnt sure, thought it came with excel / office.

basena Aug 26th, 2005 10:21 am
Re: Import excel records into ASP database
 
Quote:
Originally Posted by jpn311
Your best option is always to use the built in import/export functionality that already exists and nearly all database systems. If for some odd reason this is not an option for you, you can connect to an Excel spreadsheet and read the rows of data just like you would any other database. Your DSN-less conenction string would be similar to :

"Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=" & Server.mappath("./YourSheet.xls") & ";UID=admin;"

Just loop through the recordset, grab the values, then insert them into another db.
Hi William,

I didn't get exactly the reply u have posted. Could you please eloborate the same and explain us in detailed manner as i am also having the same type of requiremnt and struggling for the same from past long time..Thanks much in advance for your time

Bye
Aravind

basena Aug 26th, 2005 10:30 am
Re: Import excel records into ASP database
 
Quote:
Originally Posted by Cadde
Would you please send me a code for importing records in an Excel worksheet into my Asp Application database.

Your earliest response is higly appreciated. Thanking you in advance.

Aravind:

The same type of requirement i have with my project. Please anybody help us in this regards at the earliest.

Thanks

cancer10 Oct 12th, 2006 6:52 am
Re: Import excel records into ASP database
 
can this of some help?

http://support.microsoft.com/kb/321686


All times are GMT -4. The time now is 5:43 pm.

Forum system based on vBulletin Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
©2003 - 2009 DaniWeb® LLC