merge two tables problem

[Oliver Gabriel]

Hello, i have the following problem:

I have a form linked to a table, lets say tableActual.

Now, a user types in his values and saves the table in the following way:
DoCmd.TransferText acExportdelim, , "tableActual", "tableActual.txt", -1

Now, for example, he is at work, types in some values and saves them the
same way. Back home, he get´s the .txt file via email, disk or sth. else.

OK, he can import the table at home with the following code:

dbCurrent.Execute ("select * into tableNew from [tableActual.txt] in
'c:\' 'text;'")

Now i have two tables. I need them to be one, to be tableActual. So i
have to put the two tables together and to delete tableNew.

It could happen, that there are same records in both tables, and i need
to filter them before i can generate the new table.
Is there an elegant way to manage this?
regards, oli

[pietlinden]

You mean like the "Find Unmatched" query wizard? Then turn that into
an append query.

Say "tblNEW" is your new stuff, and "tblOLD" is you existing stuff.
Use the find umatched query wizard to identify all records in tblNew
that are not already in tblOld. Then turn that into an append query to
tblOld.

Run. And you're done.

Oh, and make a backup of your table before you mess something up. Then
when you're sure it's working you can ditch it.

[Oliver Gabriel]

pi********@hotmail.com wrote:

You mean like the "Find Unmatched" query wizard? Then turn that into
an append query.

Say "tblNEW" is your new stuff, and "tblOLD" is you existing stuff.
Use the find umatched query wizard to identify all records in tblNew
that are not already in tblOld. Then turn that into an append query to
tblOld.

Run. And you're done.

Oh, and make a backup of your table before you mess something up. Then
when you're sure it's working you can ditch it.

OK, that get´s me further... thanks a lot.

Oli

[Dean]

Oliver Gabriel wrote:

Hello, i have the following problem:

I have a form linked to a table, lets say tableActual.

Now, a user types in his values and saves the table in the following way:
DoCmd.TransferText acExportdelim, , "tableActual", "tableActual.txt", -1

Now, for example, he is at work, types in some values and saves them the
same way. Back home, he get´s the .txt file via email, disk or sth. else.

OK, he can import the table at home with the following code:

dbCurrent.Execute ("select * into tableNew from [tableActual.txt] in
'c:\' 'text;'")

Now i have two tables. I need them to be one, to be tableActual. So i
have to put the two tables together and to delete tableNew.

It could happen, that there are same records in both tables, and i need
to filter them before i can generate the new table.
Is there an elegant way to manage this?
regards, oli

I'd have your users knock this off and fast. Seems messy. If they
want to work from home and you still want to other users at work to
continue on, you can put you ms-access app on the web. Another thing
to consider is to allow users to come into your network remotly. If
nothing else, allow the user to get a USB mini-disk. Take the db home
(keep out users at work) and bring it back.