create table ge_flood(
PBKEY CHAR (12),
ID INTEGER,
MAPNAME CHAR (11),
TYPE CHAR (3),
STATECODE CHAR (2),
FLOODZONE CHAR (12),
PRIM_ZONE CHAR (4),
ADDL_INFO CHAR (5),
BFE_ELEV CHAR (4),
COMMNUM CHAR (6),
COMMSTATUS CHAR (3),
MAP_EFF_DATE DATE,
LOMR_DATE DATE,
CASENUMBER CHAR (20),
INIT_FHBM DATE,
INIT_FIRM DATE,
ELEVATION FLOAT,
DIST100YR FLOAT,
DISTSHX FLOAT,
ELV_PROF CHAR (512),
ELEV_PROF_DIST decimal(20,5),
WATERBODY CHAR (100)
)

---------------------------------------------------------------------------------------------------------

Bulk insert command

BULK INSERT <Table name>
FROM '<Path of data file>'
WITH
(
FIRSTROW = 2,
FIELDTERMINATOR = '|',
ROWTERMINATOR = '0x0a'
)
GO