If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
****URGENT HELP NEEDED***** updating information and running macr
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...... |
#2
|
|||
|
|||
****URGENT HELP NEEDED***** updating information and running macr
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 -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "madiziam" wrote in message ... 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...... |
#3
|
|||
|
|||
****URGENT HELP NEEDED***** updating information and running macr
On Fri, 18 Nov 2005 02:11:07 -0800, "madiziam"
wrote: 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] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Tommy Boy: Information Society - Running | R. | New Users | 0 | June 27th, 2005 10:22 AM |
Running sum query | BruceM | Running & Setting Up Queries | 3 | March 9th, 2005 02:09 PM |
Running Averages | GOL | General Discussion | 2 | February 23rd, 2005 10:48 PM |
Query Help.. Creating a running Total Field????? | Darryn Ross | Running & Setting Up Queries | 8 | October 28th, 2004 07:54 AM |
Publisher 2003 hotfix package Update (KB 838901) | Brian Kvalheim - [MSFT MVP] | Publisher | 0 | May 7th, 2004 08:38 PM |