bcp help,urgent!!!

[mkey]

Hi All,
I'm trying to bcp in to a table. The struture is something like this:
CREATE TABLE [dbo].[event_report] (
[mslink] [int] NULL ,
[id] [int] NOT NULL ,
[name] [varchar] (20) NULL ,
[report_date] [datetime] NULL ,
[type] [int] NULL ,
[umbrella_report] [int] NULL ,
[status] [int] NULL ,
[remark] [char] (240) NULL ,
[text_1] [varchar] (12) NULL ,
[text_2] [varchar] (30) NULL ,
[created_by] [varchar] (16) NULL ,
[created_date] [datetime] NULL ,
[changed_by] [varchar] (16) NULL ,
[changed_date] [datetime] NULL ,
[org_program_id] [varchar] (50) NULL ,
[chng_program_id] [varchar] (50) NULL
)
GO

and the data I am trying to insert is like this.Its in a batch file:

1008832$1008832$02221.00-002.00$$1501$$976$2216.0-2$$$SYS$2001-09-05 00:00:00.000$epe_prd$2001-10-23 11:24:41.583$MIGRATION$Microsoftr Access

I cannot seem to insert the data. In the dos prompt I'm getting this error:
Microsoft sql server driver unable to open bcp host data-file!

Can someone tell me what I'm doing wrong here?
mkey

 

[JOHN94]

LOL

 

[mkey]

I think I have solved the problem. I was trying to do a bcp out from sql server 7 while doing a bcp in, in sql 2000. When I do both bcp out and a bcp in in sql server 2000 its seems to work.
Thank you!!