Grasshoper sure, nice quote btw, well the stored procedure syntax is very interesting to me

In my original attempt I was building up a string of SQL to be executed and...

ooohh yeahhhh that works ! much appreciated. Martin

Please, no need to make fun of my typos we're all here to help each other right?

The table definition is fairly easy to work out but to make it easier:

Create...

Hello, I had to import from a lot of text files that varied in formats and had things like page numbers in that made pre-processing necessary

I used SSIS but with...

Some random ideas...

I use DOS debug.com to view small text files, eg debug myfile.txt

D - dumps next page of memory

Q - quit

Was messing around trying to get SSIS to...

Probably a *bad* answer, had problems with odbc before and would be tempted to use ms access to import into MDB then into SQL, Access does (or used to anyway)...