Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sanjay5219
Posting Yak Master
240 Posts |
 Posted - 2014-12-22 : 03:49:06
|
Hi All,
I have a Excel File which is having three columns
Roll varchar(100)
Name varchar(100)
DOJ datetime
How can I upload this in SQL via BCP Commans
Please Suggest |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
sz1
Aged Yak Warrior
555 Posts |
Posted - 2014-12-22 : 07:32:47
|
you can save the xlsx file as a tab-delimited text file and do
BULK INSERT TableName
FROM 'C:\SomeDirectory\my table.txt'
WITH
(
FIELDTERMINATOR = '\t',
ROWTERMINATOR = '\n'
)
GO
We are the creators of our own reality! |
 |
|
|
|
|
|
BCP