Updating Records As An Import
Jan 11, 2007
Ok so I have a table that has Customer Contacts logged into it. One of the fields in the table is Owner_ID. This field is a text field that contains the salespersons name that is the current "owner" of that account. Because of the business that I am in, this field can change many times within a given quarter (I will be updating every quarter). For duplication purposes (i bulk upload records from excel worksheets that the salespeople give me) I have my primary key set up as contact first name + contact last name + zip code. If I have to update lets say 400 records just to change the owner of a certain customer contact, how can I do that as a bulk import?
My first thought would be that I would have on my excel sheet the 3 fields that make up the primary key along with the 1 field (owner_id) and it would autochange the information in that particular record....but obviously I don't know how to really do this.
Please help. :)
View Replies
ADVERTISEMENT
Mar 31, 2006
I have a database with details about employees in it.
There is a field with yearly salary in it and another with an ID number. Recently these slaaries have been increased by a non-standard amount. I have another table with the emplyee ID number and their new salary. I need to update the slaary figure in the first table with the salary figure in the second table. Is there anyway of doing this?
Any help would be most appreciated
Nick:)
View 3 Replies
View Related
Sep 27, 2006
Hi there people...i'm doing a databae project for A2 level coursework and have encountered a problem..please help me if you can.
I have a table of names. Also another table (actions) which contains several fields, but 2 of them are names, (1 being Proposer, and other being Actionee), are obtained from the names table.
However, when altering for instance the spelling of one of the names in the names table it does not update the spelling in the actions table. i have tried using the relationship-update option but this doesn't work because the names appear more than once in the actions table. if it were to appear just the once in the actions table then i wouldn't have any problem. but it is a requirement that the 2 names fields are in the actions table.
Any ideas of how to solve this?
View 9 Replies
View Related
Sep 28, 2005
How can i update record in a table, for example i have 2 table PURCHASE ORDER & DELIVERY RECEIPT, the PO Table has Fieldname [PO NUMBER] & [PO BALANCE], the DR Table has Fieldname [PO NUMBER] & [DELIVERY QTY], after i entry a value in [DELIVERY QTY], when i close the form the [PO BALANCE] will update, the sequence is like this [PO BALANCE = PO BALANCE - DELIVERY QTY], any idea how can i do this in access. I used the update query but all the records in a table was updated. Only i need to update is PO BALANCE that match on both PO NUMBER. thanks in advance.
View 1 Replies
View Related
Jan 10, 2006
Im using Microsoft Access 2003 and have a form 'frm_contacts' linked to a source table 'tbl_contacts'. My frm_contacts form has a button which when pressed opens a popup form 'frm_hottarget' of some additional fields from the same source table. The frm_hottargets form contains the field 'State' which is the same field in the frm_contacts form.
What i want is to have the State field from the popup frm_hottarget form to change to the value of the State field in the frm_contacts form as soon as the button is pressed. At the moment, the only way i can get the State field from the frm_hottargets form to change to the same value as the frm_contacts form is to close both forms and reopen them, or click the next record button and then back record button from the frm_contacts form.
Any ideas? Cheers
View 2 Replies
View Related
Jun 9, 2006
Access 2000
This has to be an easy one but I can't seem to figure it out. I created a table by importing the structure from a .dbf file. Now I simply want to import other .dbf records from a bunch of .dbf files that have the exact same structure. How do Import these records into my existing table?
This should be a no brainer but I have spent an hour or so searching the help file and the internet.:mad:
View 5 Replies
View Related
Dec 23, 2004
Is there a way to import the records from another database table? I have an inventory database, blank, only the backend data is there. So everyone goes out on their own and gets inventory. At the end of the day, I would like to get flie 1, file 2, file 3, and only open file one, and only import the record from the other two inventory tables.
All these files will be exactly the same(Tables, queries,forms, everything). The only thing that will be different will be the data in the inventory table. Thanks for you help!
View 2 Replies
View Related
May 17, 2006
Hi,
I need some help, I’m trying to update 1 database which is in SQL on one server with data from another database which is on another server There are around 8000 records. It is taking for ever updating the data via MS Access Append Query and Update query. Do you know if there is any other faster way in code, which can be updated? Maybe in a loop doing 100 records at a time or any other suggestions.
Reason I need a faster way is the data on the SQL database is needs to be updated is linked to a website with data in , while the data is being updated the website crashes.
I would really appreciate your help.
Thanks
View 1 Replies
View Related
Oct 16, 2006
Hi,
I have a table with many records, and I would like to update for one of the fields, the same information as in the first record. Keep in mind that a group of records have the same attribute.
The same problem is easy to solve in EXCEL just by dragging down the info from the above cell - in this way you populate all the records with the same info as the first record, for a specific field.
How can I achieve this using ACCESS?
I want this:
FROM:
1 cost1 cost2
2 cost1
3 cost1
4 cost1
5 cost1
TO:
1 cost1 cost2
2 cost1 cost2
3 cost1 cost2
4 cost1 cost2
5 cost1 cost2
Thank you!
View 2 Replies
View Related
Sep 6, 2007
i have a query which find all the records of stock that are similar. I want to count how many of these there are. How would i go about doing this?
I then want the user to type in the system they want, how many they want, and this will "remove" the system from the list, but not from stock i.e. makes it unavailable. The query is been created from the stock, and so everytime the query is run, it would overwrite the "unavailable stock". If any one could help, this would be great!
Emily
View 2 Replies
View Related
May 9, 2005
Hey guys..
For some reason, after i added new records to my table, the fields on my form don't update... :confused: .. any idea why and how i can solve this problem ?
any help will be appriciated.
View 5 Replies
View Related
Jun 15, 2005
Underlying tables - Farmer, Field(as in crops)... Each Farmer has about 30 fields.
In a form I want to select a Farmer and then be presented with a list of his fields... I then in two text boxes want to put a date and a product name (weedkiller)... Finally, I want to select some (NOT ALL) of the fields using a tick box or similar, then press an update button and then each of the records for the fields are updated with the product name and date...
Please help I do not know where to start?
View 2 Replies
View Related
Mar 10, 2006
I have been struggling with this for weeks now and it must be fairly simple.
I have a form linked to a table with the fields
number
road
town
and
partnernumber
partnerroad
partnertown
I input the first 3 fields and I would like to be able to click a command button and copy those 3 fields to the last 3 fields to save extra typing. I cannot get the command to work though.
any help appreciated
thanks
View 7 Replies
View Related
May 22, 2013
I have a database I created. its has Units, then it has Tracts and under tracts it has Leases. the main form is for the units. then I have a sub form which is tracts. in the tracts there is a field for Leases Vol/Page. everything works great. now I have a client that wants to send me Title opinions which are for several of the leases in the tract sub form. I need to input the info in a form and have it saved in fields in each Lease at one time.
Right now I have to goto each lease and insert it every time one by one. the field for each lease is the Vol/Page field. is their a way I can do this without having to goto each lease one at a time.??????? in other words one title opinion might be the same for ten of the leases I need to update these all at once.
View 1 Replies
View Related
Jun 30, 2014
I have one form and its consists of some records. I will assign one button to that form. when i click on this button this record need to save to in another table or query. How to do this. I want to create a receipt that's why i am asking this question.
View 1 Replies
View Related
Mar 2, 2008
Hi there
I have a spreadsheet that I have successfuly imported into Access but now I would like to maintain it, update/append/delete records etc.
The spreadsheet is produced weekly and Intend to import it into my Access database on a weekly basis there are around 20,500 records and 15 Fields. I have kept the Field names in Access the same as the spreadsheet, except that the Access table has an ID field with PK and autonum. There are no other tables involved, it should just be a straight import update append ...but how?
I am looking for the best way to approach carryingout a regular update, is it best to bring the new import into a Temp table? and then carry out the analysis of what has been changed, deleted or added?
Also the queries to do this, how exactly do you get a query to scan through all of these rows and columns.
one last thing is it possible to create a table during the update/append process that will log all of the changes or flag the records using A=Append, D=Deleted U=Updated...
I've tried looking at various forums but mostly all I find is people with similar problems and no definitinve answer.
thanks
Batwings:D
View 2 Replies
View Related
Jan 23, 2006
hi all,
I have this database I'm working on and have a couple of issues I can't work out.
The first is this, I want to have my sub forms go to the last record when moving through the main form, currently I can only get this to work when I open the form?
If I move through the records in my main form (forward and backwards), the two sub forms go to the first record only, so how can I get them to go to the last recor?
I've attached the DB to show you what I mean.
Thanks in advance
Tez
View 3 Replies
View Related
Aug 21, 2006
Hi
I am tryin now (having cured my first troubles lol) to update multiple fields at once in my db from an asp web page. Code involved is
Code:DIM idid = request.querystring("id") strDSNPath = "PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};pwd=password; DBQ=" & Server.MapPath("....dbusers.mdb") strSQL_insert = "UPDATE * FROM CustRecords SET " & _"Cust_Name ='" & strName & "', " & _"Cust_LastName ='" & strLastName & "', " & _"Cust_Status ='" & strStatus & "', " & _"Cust_Orient ='" & strOrient & "', " & _"Cust_Address ='" & strAddress & "', " & _"Cust_City ='" & strCity & "', " & _"Cust_Country ='" & strCountry & "', " & _"Cust_PostCode ='" & strPostCode & "', " & _"email ='" & strEmail & "', " & _"Cust_PartName ='" & strPartName & "', " & _"Cust_PartOrient ='" & strPartOrient & "', " & _"Cust_Descrip ='" & strCustDescrip & "', " & _"Cust_Goal ='" & strGoal & "', " & _"Cust_Username ='" & strUsername & "', " & _"Cust_Password ='" & strPassword & "', " & _"Cust_Question ='" & strQuestion & "', " & _"Cust_Answer ='" & strAnswer & "', " & _"Cust_Type ='" & strLastName & "', " & _"Cust_IP ='" & strUserIP & "', " & _" WHERE id="&id Set Conn=Server.CreateObject("ADODB.Connection") Set rs = Server.CreateObject("ADODB.Recordset") Conn.Open strDSNPathConn.Execute strSQL_insert Conn.Close Set Conn = Nothing
Long winded I know but usually works and I am getting the following error
Code:Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. /sitesec/first_time1.asp, line 179
View 6 Replies
View Related
Jan 22, 2014
I have this table "tblPreventativeMaintenance" which calculates when the next appointment for service. Stored in the field "NextDueService". I have three fields in this table. "SerialNumber", "NextDueService" & "Engineer'sReport".The whole purpose of the table above is to do the calculations.Now the results of the calculations I need them to go into another table "tblInstallations" so I can use it to show Next Due Service when there is a call out in regards to certain ready installed equipment. I have same fields in both tables.I tried update query but for some reason it didn't work or at least wasn't giving me the results I needed from it.
View 8 Replies
View Related
May 10, 2014
I created a new form with two subforms. They each reference their own table but are linked by a field called Case_Name. I created a unbound combo box in the main form to allow filtering of the records based on Case_name and I do a requery when the record is found. I am importing data from another application into the three tables ( main with other fields, as well as other tables ..Case_Name only).
The form/subforms are then used to modify or add new data to the existing records in each table/subform. The problem I have is when I go to update/add data in the subforms, it comes back and tells me that it cannot add data due to data integrity. It thinks I am trying to add a new record with the same Case_Name. I have the forms and subforms set up as Data Entry = No so that no new records can be added. I only want to modify existing data as the records are created from the import process.
View 5 Replies
View Related
Jan 30, 2014
I have two tables -say Table A and Table B.
Table A Table B
ID userno ticketno Status userno ticketno Status
1 1211 YAB 1211 YAB LIVE
2 1211 YAB 1232 ACE LIVE
3 1232 ACE 1232 AAT INVALID
4 1232 ACE
5 1232 ACE
6 1232 AAT
I am trying to write an update query in MS Access that will update only the first record of any custno with the status so that my final table A looks like this:
Table A
ID userno ticketno Status
1 1211 YAB LIVE
2 1211 YAB
3 1232 ACE LIVE
4 1232 ACE
5 1232 ACE
6 1232 AAT INVALID
How to write the query.
View 3 Replies
View Related
Jan 29, 2013
I have a database too big to upload here at the moment, however i have a main data entry form that is based on more than one table, what i want to do is create an email form either as html or info point and have this form emailed out so that my colleagues can then fill in thus on its return add records to the database.
View 1 Replies
View Related
Jun 3, 2013
I'm getting an import error that records are being 3 records being deleted and one lost due to violations. However when I go back to check the data that was imported I can't find anything missing. Any clues on what could cause the error but still import the data.
View 1 Replies
View Related
Oct 16, 2012
I am trying to import a series of records from Excel into a table in Access 2010. The field names in the Excel table match the field names in the Access table. The field formats are the same as well (both set to numbers).
I am receiving an "unparsable record" error for all fields in the Excel file that are being entered into fields in Access that are 'lookup' fields that allow multiple entries.
The Exel fields have been filed in with the 'numbers' that correspond to the correct 'lookup' selections. There is only one item in the excel field -> while access will allow multiple entries for the field, I for the records I'm importing I only need one.
For the fields that are 'lookup' but allow only one value the excel data is being imported and displayed correctly in Access.
Do I need to format the fields that are matching to multiple entry fields differently or in a special way?
View 7 Replies
View Related
Dec 10, 2007
I currently have a database that is missing various pieces of information, we are getting a temp in to complete this. I don't want the temp adding data directly into Access so I have exported the table that needs updating into Excel.
How can I then import the new data without altering current data.
I know this is no problem for new records, but if I have a current record with a few fields of information missing how can I just import information into the blank fields. This can't be a manual process as there are hundreds of records.
Any comments would be much appreciated!
Chris
View 1 Replies
View Related
Nov 3, 2005
I created an update query that says it has successfully updated 600 records, but when you go into the table, it has not been updated. I am working with an .mde. Does that make a difference?
I first created a select query to find everyone in TX. Then I changed it to an update query to change all TX to CA. Since it did not update the table, I tried running the update query again and this time it says there are not records to update (since it uppposedly updated my 600 records).
Your help is appreciated.
View 1 Replies
View Related
