reading from a table

hi !!
i have a database name as tempdb
in which the data is

TIMESTAMP,Sun,Nov,24,21:15:23,2002
a,b,c,d
e,f,g,h
TIMESTAMP,Sun,Nov,24,21:16:23,2002
i,j,k,l
m,n,o,p

this is a log file generated......and has thousands of records in it.
So i need this data to be inserted in another database
w.r.t the time as it is generated after ONE minute for eg:

a,b,c,d,24Nov,21:15:23
e,f,g,h,24Nov,21:15:23
i,j,k,l,24Nov,21:16:23
m,n,o,p,24Nov,21:15:23

So the problem is how do i Pick the records (Time) from the tempdb and insert into a different Database.

pls help
hope i was clear enough
waitin replies

What are the fields in this tempdb ?. I don't think all that data would be stored in just one field per record !!. If you know the field which contain the time, you can write a SQL statement or just filter the recordset using the filter method and write them out to another table.

Pls tell me If I need to be more descriptive :)

hi
thanx for your time
I am importing a text file in to my database
as i import the data also contains null value
so after i import i have to pick data according to the time and day to insert into a new database
You can see the following file i am importing to a temp database and that data i need to store in final db w.r.t to the Time.

pls help
Any help is usefull for me.....

________________________

pls see this file which contains the temp data