How i upload excel file and how i add all data in my sql database ?

Posted by Parag under ASP.NET on 6/5/2008 | Views : 3146 | Status : [Member] | Replies : 4

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

I have 1 excel file. in file some fields like name,in time, out time, day, etc..
And My sql database has same fields table name Details.

I want to upload this excel file. And when i upload file all data set in my sql database Table(Details).

Like in Excel file field like :
Name In time Out Time
Parag 9:00 AM 7:00 PM

when i upload file i want to all data in my sql database table(Details)(at that time). Like

In my database table fields like :
Name In time Out Time
Parag 9:00 AM 7:00 PM

Give me simple coding please.

parag barot

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Jayakumars on: 9/30/2012 [Member] [MVP] Bronze | Points: 25

0	hi refer this http://blog.tjitjing.com/index.php/2008/02/import-excel-data-into-mysql-in-5-easy.html http://stackoverflow.com/questions/11893501/import-an-excel-csv-into-mysql-using-php-code-and-an-html-form http://www.tech-recipes.com/rx/2345/import_csv_file_directly_into_mysql/ Mark as Answer if its helpful to you Kumaraspcode2009@gmail.com Parag, if this helps please login to Mark As Answer. \| Alert Moderator

hi

refer this


http://blog.tjitjing.com/index.php/2008/02/import-excel-data-into-mysql-in-5-easy.html 

http://stackoverflow.com/questions/11893501/import-an-excel-csv-into-mysql-using-php-code-and-an-html-form 

http://www.tech-recipes.com/rx/2345/import_csv_file_directly_into_mysql/

Mark as Answer if its helpful to you

Kumaraspcode2009@gmail.com

Parag, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jayakumars on: 9/30/2012 [Member] [MVP] Bronze | Points: 25

0	hi Please mark as answer Resolved Posts if it helpful to you. Mark as Answer if its helpful to you Kumaraspcode2009@gmail.com Parag, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Sandeepmhatre on: 10/1/2012 [Member] Starter | Points: 25

0	Best way to upload excel to database is using SSIS ie integration services. by converting the Excel file into CSV you can upload excel file in database with less amount of code. Sandeep M, Software Developer Follow me on : http://sandeepmhatre.blogspot.in Parag, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: SheoNarayan on: 6/5/2008 [Administrator] HonoraryPlatinum

0	Please look at following article for the solution. http://lakshmik.blogspot.com/2005/12/how-to-get-excel-data-into-net-dataset.html http://support.microsoft.com/default.aspx?scid=kb;en-us;194124 http://mow001.blogspot.com/2005/12/using-ado-to-get-data-from-excel-to.html Thanks Regards, Sheo Narayan http://www.dotnetfunda.com Parag, if this helps please login to Mark As Answer. \| Alert Moderator

Please look at following article for the solution.

http://lakshmik.blogspot.com/2005/12/how-to-get-excel-data-into-net-dataset.html

http://support.microsoft.com/default.aspx?scid=kb;en-us;194124

http://mow001.blogspot.com/2005/12/using-ado-to-get-data-from-excel-to.html

Thanks

Regards,
Sheo Narayan
http://www.dotnetfunda.com

Parag, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts