Re: adding new records from one table to an existing table

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks for the help. I'm an idiot. That was so ridiculously easy.


On Jul 6, 11:11 am, "kingston via AccessMonster.com" <u27511@uwe>
wrote:
You're on the right track by using an append query. What happens when you
try to run the query? Is there an error message? Make sure you set the
Append To: line correctly since the field names are not the same (e.g. Field:
Original Address 1 and Append To: Address 1). Also, if there is a required
field in the target table that doesn't exist in the source table, you may
need to enter default data in the Field: line.

Josh Wexler wrote:
I'm pretty new to access so please bear with me. This may be really
simple. I have a table listing thousands of existing stores. In the
existing table i have a lot of geographic information including lat/
long, address, etc. Periodically I will need to add new records from
another table. However, in the new table the field names aren't
identical. ie....in the original table i have Original Address 1 and
in the new table it says Address 1. I also don't have all the fields
in the new table. So i need to add in the new records with their
corresponding fields(i will fill in the missing fields later). i
can't seem to do this. I have been trying to do an append query, but
it's failing, i believe due to having different named fields.

Thanks for any help.

--
Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200707/1


.

Relevant Pages

  • Re: Cant append all records in the record query
    ... "Efficiency can't append all the records in the append query. ... Efficiency set 1 fieldto Null due to a type conversion failure, ... > Is that the exact and complete text of the error message? ...
    (microsoft.public.access.forms)
  • Re: Running into error while writing Append Query
    ... If the error message is to be believed, ... Check your data -- if you change that Append query to a Select query, ... didn't add 1 recordto the table due ot key violations, ...
    (microsoft.public.access.queries)
  • Appending text to existing value in table column
    ... In this column i am storing information/error messages. ... Every time an error occurs i want to append ... that error message to already existing text in this ... I am trying to use the below query, ...
    (microsoft.public.sqlserver.programming)
  • Re: Violence due to primary key problem in Append Query
    ... It depends on how you are going about running the query. ... If you are doing it via a macro using the OpenQuery action, you can precede it by a SetWarnings/No action. ... it shows the error message "Microsoft Access cannot append all the data in the Append query". ...
    (microsoft.public.access.queries)
  • Re: Membership database updates
    ... When you open any Query in Design View, click on the toolbar just next to ... black down-arrow where you can change your query to an Append or Update ... If you have any current members in your Import list, ... You mention Update Queries and Append Queries but I can't find how to ...
    (microsoft.public.access.tablesdbdesign)