将csv文件导入表中 [英] importing csv file into a table
问题描述
我们使用以下代码将.csv文件中的数据导入表格
We use the following code to import data from .csv file into a table
ALTER PROCEDURE [dbo]。[ EXEC_Import_External]
AS
设置NOCOUNT ON;
truncate table dbo.Store_Master
BULK INSERT dbo.Store_Master
FROM'D:\ SalesData.txt'< br $>
WITH¥b $ b(
FIELDTERMINATOR ='\ t',
ROWTERMINATOR ='\ n',
FIRSTROW = 2
)
如果总是向该表输入一个额外的空行,会发生什么。 &NBSP;我该如何防止这种情况?
ALTER PROCEDURE [dbo].[EXEC_Import_External]
AS
SET NOCOUNT ON;
truncate table dbo.Store_Master
BULK INSERT dbo.Store_Master
FROM 'D:\SalesData.txt'
WITH
(
FIELDTERMINATOR = '\t',
ROWTERMINATOR = '\n',
FIRSTROW = 2
)
what happens is that if always imports an extra empty row to this table. How can I prevent this?
谢谢
patyk
推荐答案
嗨Patyk,
Hi Patyk,
请你发帖,示例SalesData.txt
Can you please post, sample SalesData.txt
谢谢!
这篇关于将csv文件导入表中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!