|
Niki
Starting Member
45 Posts |
 Posted - 01/09/2013 : 12:45:07
|
IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME = 'TblTempCPA')
DROP TABLE TblTempCPA
GO
CREATE TABLE TblTempCPA
(
StudentNo Varchar(10) NOT NULL,
StudentName Varchar(100),
ExitReason Varchar(10),
CompletionSts Varchar(10),
CONSTRAINT pk_TblTempCPA PRIMARY KEY (StudentNo)
);
GO
bcp dbo.TblTempCPA in 'C:\Current_CPA_CTE.xlsx' -T
The error I am getting is -
Msg 102, Level 15, State 1, Line 4
Incorrect syntax near '.'.
My excel sheet may have duplicate Studentno though. Is that the problem or BCP syntax?
Niki |
|
Bulk Copy Error - Please help
