BCP in a table

  • Comments posted to this topic are about the item BCP in a table

  • The SP fails when my table has a column name beginning with a numeric.


    CREATE TABLE [dbo].[txgeoTable]


    [EDIPOKey] [int] NOT NULL ,

    [TranNo] [char] (10) NULL ,

    [940SentDate] [datetime] NULL ,

    [Status] [char] (1) NULL



    This works ok.

    EXEC dbsp_bcp_out txgeoTable, mydb, 'c:\'

    This doesn't work.

    EXEC dbsp_bcp_in txgeoTable, mydb, 'c:\'

    Error Message:

    Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '940'.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply