Y I
asked on
"ImportFromExcel" does not exist
When I try to import csv file from Microsoft SSMS by using "ImportFromExcel", it says that "ImportFromExcel" does not exist. Please see the attachment. How can I enable this option?
no attachment, which version of ssms?
ASKER
Thank you. SSMS version is v17.91
ASKER
sorry, v17.9.1
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you! I could import from import/export wizard.
I would like to import data by using BULK INSERT statement too.
When I run the following statement, it says "ImportFromExcel" does not exist. It's appreciate if I can know how to avoid this message.
USE ImportFromExcel;
GO
BULK INSERT Data_bi FROM 'C:\data.csv'
WITH (
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
);
GO
I would like to import data by using BULK INSERT statement too.
When I run the following statement, it says "ImportFromExcel" does not exist. It's appreciate if I can know how to avoid this message.
USE ImportFromExcel;
GO
BULK INSERT Data_bi FROM 'C:\data.csv'
WITH (
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
);
GO
ASKER
The attachment is a message from SSIS.
message.JPG
message.JPG
ASKER
Sorry, typo, it's not SSIS. It's a message from Microsoft SSMS.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you very much! I could insert data with BULK statement. Thank you,
ASKER
Thank you very much! It was very helpful comment. If I didn't ask here, I may spend hours for this problem. Thank you!
You're welcome