My Feeling is that it would be a good thing to know how much anyone in the company is paid

as it's done in European Institution (European Commission etc) and particularly...

this last method is a good one but just to not forget to use double quote and not single quote in your expression

RIGH("00"...

Jeff,

could you guide me througth the diffrent steps you mentioned ?

1.Import flat file in a temp table with one colonne : ok

bulk insert ANYDB.dbo.TmpFileTable

from 'd:\MyOriginalDataFile.txt'

...

I'm using an Application named automate is executing different macros to execute mutiliple recurrent and repetitive tasks.

That's why I'm talking about macros

I just sent you a bigger file

I know that there are actually5 data rows + 1 header and 1 footer thus 7 rows

But what I say is that I'm using...

what I do not understand is when I use an oledb drive to read the file in a datase

he gives a totalrows = 7

Maybe there is a way to import...

sent

I have no problem to attach the script but I prefer to send the data file separately and in private

if possible

it is the case, the header has exactly the same deimiters than the others, I checked it with Notepad++