将excel表数据导入asp.net中的sql数据库

本文介绍了将excel表数据导入asp中的sql数据库的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

你好， 我有一个要求，我有excel表，我想将数据存储到sql数据库。我是asp的新手。任何人都可以帮助解决这个问题。我是否需要先创建数据库模式？我在很多论坛上发现了很多这方面的脚本。我曾提到www.aspdotnet-suresh/2012/12/how-to-import-data-from-excel-to-aspnet.html 但是想知道是否假设excel文档包含4张，所以我需要提前创建4个表来存储数据以导出到gridview。 请通过提供分步信息来帮助我。 提前致谢。

解决方案

第一步右键点击你的数据库 然后转到任务选择导入数据 现在提供你的sql的authencity和密码点击下一步并完成

Hello, I have a requirement in which I have excel sheet which I want to store data into sql database. I am completely new to asp. Can any one help how to go about it. Do I need to create database schema first? I found many scripts regarding this in many forums. I had referred www.aspdotnet-suresh/2012/12/how-to-import-data-from-excel-to-aspnet.html But want to know if suppose excel document contains 4 sheets, so do i need to create 4 tables in advance to store data to export to gridview. Please help me by providing step by step information. Thanks in advance.

解决方案

First step Right click on your database then go to task select import data now provide authencity and password of your sql the click on next and finish