将excel表数据导入asp.net中的sql数据库 [英] To import excel sheet data into sql database in asp.net

问题描述

你好，



我有一个要求，我有excel表，我想将数据存储到sql数据库。我是asp.net的新手。任何人都可以帮助解决这个问题。我是否需要先创建数据库模式？我在很多论坛上发现了很多这方面的脚本。我曾提到http://www.aspdotnet-suresh.com/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.net. 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 http://www.aspdotnet-suresh.com/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

这篇关于将excel表数据导入asp.net中的sql数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！