Regarding the C#, I previously created an App that did exactly what i want to do in SQL, however it ran out of Memory due to the size and amount...

Yes sorry an SQL server database.

I will see what i can learn from using a script, many thanks for the idea.

I'll come back once i hit the next issue.

Thanks

Rixxe.

Well for example, i have a folder in C:Named Database. In that folder are files like:

patient.0001 etc etc

The name of the table would therefore be patient0001 in SQL, thats what...

No, i wan't to select specific records from each file, and then put them all into one table, I can deal with the last part of the problem.

I cannot however...

Steve Jones - SSC Editor (12/14/2010)

---

What do you mean by date conversions? NULL doesn't convert to anything but NULL.

NULL might be your best bet. You can always do MINDATE() ......

Steve Jones - SSC Editor (12/13/2010)

---

As far as the conversion, you need a valid date, no matter what the format. If there is '00000', this isn't remotely valid.

What you...