Problem with quotes in the Bulk Insert - normally I use what you suggested

BULK INSERT temp FROM ''' (plus) @file (plus) '''

But in this case - my actual filename has quotes around it. It comes from a mainframe and for whatever reason thats the way the frame creates the filenames.

I tried using the "normal" way - but I get the following error:

Server: Msg 170, Level 15, State 1, Line 2

Line 2: Incorrect syntax near 'ECM'.

(the filename is 'ECM.DM.LIST.0001000037.TEST' (quotes and all)

The actual syntax of the bulk insert (at run-time) is:

BULK INSERT temploadswbt FROM '\\Chicagofs\Ameritech\Sbc\'ECM.DM.LIST.0001000037.TEST''

WITH (

FORMATFILE = 'g:\sbcdata\swbtpb_new.fmt' )

anyone have any ideas? Thanks!!