Thanks for taking the time to read this, as you guessed already I need a bit of help
Okay here’s the deal !

I have set up an access DB with the table reeldata , this table has info on reels of melinex that have been made on the shop floor.
Every two hours a text file gets read with yesterdays and todays data from the shop floor. So far I have set up the access tables like this:

table one is a temp table which has the text file attached to it, everything is read in as text, then I copy the contents of table one into table two which is set up exactly the same fields except some of the fields are numeric instead of text ( this was the only way I could find to get the data in from a text file into a format which I could work with. It’s a kind of translation. The data is for 48 hours , but the table 2 real table must grow and grow to contain lots of data, a build up of the collected data.

every two hours the file is read in, I want the real table to grow and not be overwritten by the temp table. I guess I want to append to the real table ( table two ).

Does this make sense ? , I hope so

example:

first pass:
real table temp table
1 <- 1
2 <- 2
3 <- 3

second pass:
real table temp table
1 <- 1
2 <- 2
3 <- 3
<-- 4
<-- 5
<-- 6

here I only want to put the 4 , 5, 6 into the real table.
I dont want to overwrite the real table records 1,2,3

sorry for the long post can anyone help me, please.
whats the best way to go about this ?

Thanx for your time
Locutus

[Edited by locutus on 07-17-2000 at 10:55 AM]