How to import data from one table and save it to another table .

[OC2]

Hi,

I know this may have been answered b4, but not specifically to my database.

im importing a file with these fields onto table "OLSimport",

product code
transaction date
location
remarks

I have created another table "OLS" with these fields in which i want data from olsimport to save to

product code
transaction date
location
remarks
Time
Confirm

my aim is to import data to table OLSimport, the data from this table will then show up on my form (which includes the Time and confirmation field from the OLS table) I want to then confirm this information and save it to the OLS table. The reason im not using the OLSimport table as my main table is because It will be replaced everday with an updated version.
This is a database to veryfy and store information from one table to another using 1 form.

Can anyone help.

thx

 

[ghubbell]

Hi OC2,
Set up an Append query. That's a regular query based off your first table, but choose query type off the tool bar. It will ask which table (you pick) and Immediately you should see the similarly named fields fill in in the grid. Anything you don't want to "Append to", either remove the column, or remove the "append to" field name. If you want to do this and have the time of the operation automatically entered for you, go to the "OLS" table and set the "default Value" for the Time to Now() .
Gord
ghubbell@total.net

 

[OC2]

thx that worked

a few things i need to touch up on, but ill work that out myself