将Excel数据导入SQL Server [英] Importing excel data to SQL server
问题描述
Hello Everyone,
我试图通过导入向导将多个excel文件导入sql server。
这些文件包含很大的文件名单和电子邮件地址列表。
完成导入一个文件后的问题(我已经在目标表中创建了一个ID列,自动递增),其余文件没有按顺序排列ID序列。
如何基于最后一个自动递增ID号来附加其余文件。
我无法编辑SQL在导入向导中
我尝试过:
我试过了在excel表中添加一个字段。
启用身份插入,它没有帮助
Hello Everyone ,
I am trying to import multiple excel files into sql server through import wizard .
The files contain a big list of names and email addresses .
The problem after finishing import of one file ( I have created a ID column into destination table , auto increment ) , the rest files don't have the ID sequences in order .
How can I append the rest files , based the auto incrementing id number based on the last .
I cannot edit the SQL in the import wizard
What I have tried:
I tried adding a field in thje excel sheet .
enabling identity insert , it didn't help
推荐答案
很多研究证明这是不可能的。
需要对excel文件进行重组以适应数据,并且需要添加缺少的列。
我能够插入数据。
A lot of research proved that it's impossible .
The excel files need to be restructured to fit the data , and the missing columns need to be added .
I was able to insert data .
这篇关于将Excel数据导入SQL Server的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!