Make sure that the windows account Sql Server is running under has access to the data and format files. It's also better to use UNC names when referencing files.

>Please help! I need to run this simple statement tonight:
>
>BULK INSERT Promo_History_Staging_Raw
>FROM 'H:\PromoHist\Test.txt' WITH ( FORMATFILE = 'H:\PromoHist\PromoHist.fmt' )
>
>But I get this error:
>
>Server: Msg 156, Level 15, State 1, Line 1
>Incorrect syntax near the keyword 'from'.
>
>Any idea? The files exist, the server/table is fine. I just don't get what it wants.
>
>Jesse