You can do this with this command:

-- Local Server:

if OBJECT_ID('tempdb..#tmp1') IS NOT NULL drop table #tmp1

CREATE TABLE #tmp1 ( codigo BIGINT, descricao VARCHAR(100) )

-- Insert in a Temporary Table

BULK INSERT #tmp1 FROM 'C:\Documents and Settings\hb.VANTYX\Desktop\ExemplosFicheiros\hb_teste.txt'

WITH

(

FIRSTROW = 2,

FIELDTERMINATOR =';',

CODEPAGE = 'ACP'

);

-- Insert into the intended table:

INSERT INTO BERNOULLI.ACP_DB_03_8081.dbo.hb_teste

SELECT * FROM #tmp1