Thanks for the replay but that not help, I need to evaluate if the field="LBO" and then sum another field

I need to show at the end of the report something...

it's not 2000, it's 2005

I tried with [slash]r and nothing, same error, any other idea??

thanks

Nelson

I think it's something with the txt files, if I change the field 4 for a char(5000) it works

but put all in one line

like this

1JamesSmith19750101 2,Meggie,Smith,19790122 3,Robert,Smith,20071101 ,Alex,Smith,20040202...

sorry bother you with this, but, I alter my code and source

source is this:

1,James,Smith,19750101

2,Meggie,Smith,19790122

3,Robert,Smith,20071101

4,Alex,Smith,20040202

code is this:

CREATE TABLE nelson_test1 (

Field1 ...

OK i'm doing your way and still get an error this is my code;

drop table nelson_test1

CREATE TABLE nelson_test1 (

Field1 ...

ok I'm trying to test this way and I'm getting an error:

BULK INSERT #temp1 (field1,field2,field3,field4,field5) FROM 'c:elson.txt'

WITH

...

that's it..THANK YOU !!!!!!!!!!!!!!

DO I NEED TO CREATE A DIAGRAM?