****URGENT HELP NEEDED***** updating information and running macr

[Guest]

I need to sort this out today if possible as I don't have much time to work
on it after that.
I have set up a DB at work and each month we will receive data in delimited
txt format. I need to be able to update the DB (5 tables) with this data.
It needs to be set up so that a macro can be run to do this as other people
need to be able to carry out the update.

I have set up a trial table and linked them with a LEFT JOIN, but I can
only see the records that are from the new trial table, but it is showing
that it has the same number of records as the old table but the records are
coming up blank???? I have used Access a lot but don't know enough about it
to use it in depth without help......

 

[Douglas J. Steele]

That's exactly what a LEFT JOIN is intended to do: it connects two tables,
showing one row for every row in the left-hand table. For those rows in the
right-hand table that match the left-hand table, it shows the values from
the right-hand table. For those rows in the right-hand table that don't
match the left-hand table, it shows blanks.

If what you're trying to do is update matching rows in the existing table,
or insert new ones that are in the new table but not the existing table,
take a look at my November, 2003 "Access Answers" column in Pinnacle
Publication's "Smart Access"

You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

 

[John Vinson]

I need to sort this out today if possible as I don't have much time to work
on it after that.
I have set up a DB at work and each month we will receive data in delimited
txt format. I need to be able to update the DB (5 tables) with this data.
It needs to be set up so that a macro can be run to do this as other people
need to be able to carry out the update.

I have set up a trial table and linked them with a LEFT JOIN, but I can
only see the records that are from the new trial table, but it is showing
that it has the same number of records as the old table but the records are
coming up blank???? I have used Access a lot but don't know enough about it
to use it in depth without help......

A Left Join will let you create an Update query to update the fields
in existing records, but it won't add new records.

I'd suggest running an Append query if that's what you want to do
(append new records into your table).

You don't describe your table structure or exactly what you want to do
with the received data, so it's rather hard to advise!

John W. Vinson[MVP]