I'm trying to insert data from an xlsx file into my temporal table. I've also tried with a real table, but it throws me the following error:
(0 rows affected)
I'm pretty sure my error is in the bulk insert part, because when I run just that part it throws me the same error.
This is the statement I am using to insert the data:
IF OBJECT_ID('tempdb..#stats_ddl') is not null DROP TABLE #stats_ddl GO CREATE TABLE #stats_ddl ([Fecha] varchar(50), [Descripción] varchar(max), [Depósitos] varchar(50), [Retiros] varchar(50), [Saldo] varchar(50)); Go bulk insert mydb.dbo.#stats_ddl from 'C:\some\where\myfile\is\file.xlsx' with ( firstrow = 14, FIELDTERMINATOR = '\t', ROWTERMINATOR = '\n')
I am receiving this error:
Database name 'mydb' ignored, referencing object in tempdb.
What issues am I facing?