Lowell (9/22/2007)

---

sorry, i cant seem to see how you know which column is which;there's no obvious pattern in the sample you rpovided.

If you could determine that column 3 was always...

1: Always skip the first line of the file no matter what...

2: The second line of the file will always have what the correct column order for the data is...

3:...

ok, some sample data

randomdata;10/10/2007;randomdata;randomdata;

Column1;Column3;Column5;Column4;Column2;

jk adkshfjhjkfhsajkfh sda;sdfs dfasdfsda;fsdaf sadfadsfsda;

dsf;sdf;sdf;sdfds;sdfsd;

So, here is the description.

First line, i dont want it to be in the table, but contains date that i want to store.

Then...