我想知道从Excel导入数据到SQL Server时的插入查询语法 [英] I want to know insert query syntax while import data from excel to sql server

问题描述

hi

我想知道从excel表格导入数据时的插入查询语法.
因为我收到了类似"FROM子句中的语法错误"之类的错误.告诉我我的错误.

hi

I want to know insert query syntax while import data from excel sheet.
Because I got error like ''Syntax Error in FROM clause''. Tell me my mistake.

I already tried followig queries

Insert into Table_1(Id,FirstName,LastName) SELECT A.[Id], A.[FirstName], A.[LastName] FROM OPENROWSET ('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=E:\RAJ Infotech\testfile.xls;HDR=YES', 'select * from [Sheet1$]') AS A ; SELECT * FROM MainAdmin.dbo.Table_1

SELECT * INTO Table_1 FROM OPENROWSET(''Microsoft.Jet.OLEDB.4.0'',''Excel 8.0;Database=" & Server.MapPath("testfile1.xls") & ", [Sheet1$])

SELECT * INTO Table_1 FROM OPENQUERY(EXCELLINK,SELECT * FROM [Sheet1$]'') 

但是我发现了同样的错误.请帮助我.

另一个疑问是:

查询本身是否可能检查具有相关工作表字段的数据库字段?如果是，那么告诉我如何?

but i found same error.please help me.

Another doubt is:

Is it possible that query itself check the database field with related worksheet field ? if yes then tell me how?

推荐答案

') AS A； 选择 * FROM MainAdmin.dbo.Table_1

') AS A ; SELECT * FROM MainAdmin.dbo.Table_1

SELECT * INTO Table_1 FROM OPENROWSET(''Microsoft.Jet.OLEDB.4.0'',''Excel 8.0;Database=" & Server.MapPath("testfile1.xls") & ", [Sheet1

)

SELECT * INTO Table_1 FROM OPENQUERY(EXCELLINK,SELECT * FROM [Sheet1

'')

但是我发现了同样的错误.请帮助我.

另一个疑问是:

查询本身是否可能检查具有相关工作表字段的数据库字段?如果是，那么告诉我如何?

but i found same error.please help me.

Another doubt is:

Is it possible that query itself check the database field with related worksheet field ? if yes then tell me how?

这篇关于我想知道从Excel导入数据到SQL Server时的插入查询语法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！