473,320 Members | 2,048 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How do I import data into an existing table to update the records?

52
Hi!

I have a table of names and addresses, all keyed off of the student ID number. I want to import email addresses for these records using an Excel spreadsheet that contains only the ID numbers and email addresses. That is, I simply want to add the email addresses to the correct people who are already in my table.

It seems so simple, but how in the heck do I do it? I just can't figure out what to search for to find my answer. My apologies if this has already been answered.

Thanks!
Jan 10 '11 #1
2 2704
Mariostg
332 100+
Import your excel spreadsheet into a table in your access database.
Execute an update query to set the email address based on matching student ID
Jan 10 '11 #2
Mmmel
52
Great! This was incredibly helpful. Thanks for taking the time to help me out! Got it finished now! : )
Jan 10 '11 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: dev | last post by:
how create a temp table as a copy of a existing table and then update1 field and insert the hole temp table back in the existing table? please any help? if i have 10 fields in 1 record and...
3
by: John Kolvereid | last post by:
How does one import data INTO a table. I am forced to read files (\i) w/ a ton of insert statements. I am trying to import approx 800 lines into the table. However, I must bundle them into a...
0
by: DataFreakFromUtah | last post by:
Hello! No question here, just a procedure for the archive. Search critera: count records imported count data imported count number of rows imported count number of records imported record import...
1
by: deko | last post by:
DoCmd.CopyObject copies data, but I only need structure. I'm trying to clone several tables in my Access 2003 mdb. The goal is to link to a series of Excel spreadsheets and then run various...
4
by: Bri | last post by:
Hi, First let me explain the process I have going on, then I'll address the problems I'm having: 1) Insert records in a temp table using a query 2) Using a query that joins the temp table with...
1
by: Robcast | last post by:
Hi, i need to import data from table A (Oracle Server X) to table B (Oracle Server Y) i've got my both OracleConnection object initialized & working do u think i can do that using...
10
by: Washington | last post by:
How I can import new data form table in existing one. The tables are same, for e.g. Table 1 ID | FirstName | Last Name Table 2 ID | FirstName | Last Name Only data are different.
2
by: Mast3rMind | last post by:
Hi, I'm currently programming in C# 2.0 and I need to code a process that imports data from one table to an other, by using a query of type: (SELECT * from table_source where champs in (value1,...
9
by: a | last post by:
Dear friends I want import data from CSV file to mdb file How can I do that in vb.net?
7
by: ndhvu | last post by:
Tables: Buy_Header and Buy_Detail. - Buy_Header: info. of each buy (buy_id(PK, auto number), date, shop, bought_by, ...) - Buy_Detail: info. of each item from each buy (buy_detail_id(PK, auto...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.