SQL Syntax problem w/ LOAD DATA

[edward wong]

I am trying to load a table using LOAD DATA and have syntax issues with the optional FIELD clause

LOAD DATA LOCAL INFILE 'rss_account_extract_stg.txt'

INTO TABLE rss_account_extract_stg
(
ACCT_ID,
SA_ID,
SP_ID
)
FIELDS TERMINATED BY '|' ;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FIELDS TERMINATED BY '|'' ;

Any ideas? I'm on version 5.6. Thanks in advance.

cheers,
edward