将数据从Excel导入到Sqlserver [英] Importing Data From Excel to Sqlserver

问题描述

我必须将数据从excel导入到sqlserver，但是前4-5行必须忽略，因为它是无用的信息.我知道sql批量复制方法，但不知道如何忽略前4-5行.

谁能帮我...

I have to import data from excel to sqlserver, but first 4-5 rows has to be ignored because it is unwated information. I know the sql bulk copy method but don''t know how to ignore first 4-5 rows.

Can anyone help me...

推荐答案

尝试
使用ASP中的C#将数据从excel导入到SQL Server. NET [ ^ ]
将数据从Excel导入到SQL Server [ ^ ]
如何使用c#.net [使用c#导入Excel数据 [

Try
Import Data from excel to SQL server using C# in ASP. NET[^]
Import Data from Excel to SQL Server[^]
How to import MS Excel data to SQL Server table using c#.net[^]
Import Excel data using c# [^]

您好，

我有一个已开发的工具，您可以在其中选择Excel工作表中的范围，然后取消选择不需要的行和列.
然后，您还可以将选定的列映射到要存储Excel数据的表中的SQL Server列.

我将以商业形式发布该软件，但我将向SLQ/BI地区的人们再分发一周左右的许可证，以获取反馈.

如果您对副本感兴趣，请在 www.sqlspreads.com 上注册试用版，或通过johannes.akesson@obnex给我发送电子邮件. .com，我可以帮助您入门.

最好的问候

约翰尼斯·阿克斯森(Johannes Akesson)

Hi,

I have a tool that I have developed where you can select a range in the Excel sheet and then unselect unwanted rows and columns.
Then you can also map the selected columns to the SQL Server columns in the table where you would like to store the Excel data.

I will release the software as commercial but I give away licenses for another week or so to people in the SLQ/BI area to get feedback.

If you are interested of a copy, sign up for a trial on www.sqlspreads.com or send me an email at [e-mail] and I can help you to get started.

Best regards

Johannes Akesson

这篇关于将数据从Excel导入到Sqlserver的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！