-
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]
-
I believe what you want to do is to append the records from the "temp" table (which gets overwritten every time) to the "real" table, where you maintain history. To do this in VB with a SQL statement, you can code something like:
dbMyDB.Execute "INSERT INTO RealTable SELECT * FROM TempTable"
