473,327 Members | 1,952 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,327 software developers and data experts.

How to append new data (column) in an existing table?

91
When I am appending new data to an empty existing field in an existing table, the data is being added after the last record (row) in the table.

I would like to place the data in a "side-by-side" manner.

I am using SELECT INTO AND INNER JOIN SQL to append the data.

Eg, the after running the query the table looks like.

col1 | col2 | col3
-----|------|--------
a |b |
c |d |
e |f |
| |g
| |h

I would like to place g,h... in col3 from row1 beside b,d....

Is there any ways to do this? I am also attaching the screen shots.
Looking forward for your suggestions.
Attached Files
File Type: doc append.doc (235.0 KB, 385 views)
File Type: pdf append.pdf (200.3 KB, 376 views)
Mar 14 '12 #1

✓ answered by NeoPa

Again, JPEGs is the way for showing pictures.

Anyway, you don't use the term APPEND in relation to SQL when your talking about populating fields in existing records. That would be UPDATE (and an UPDATE query). You are simply changing the values of these pre-existing fields to different data.

3 8313
NeoPa
32,556 Expert Mod 16PB
Again, JPEGs is the way for showing pictures.

Anyway, you don't use the term APPEND in relation to SQL when your talking about populating fields in existing records. That would be UPDATE (and an UPDATE query). You are simply changing the values of these pre-existing fields to different data.
Mar 14 '12 #2
sg2808
91
Thanks NeoPa. I realised later that "Update" is the right tool to do this and hence my other query on "Update".
Mar 14 '12 #3
NeoPa
32,556 Expert Mod 16PB
A quick note to that effect may have saved some time then ;-) Never mind. Next time.
Mar 14 '12 #4

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

Similar topics

4
by: dave | last post by:
I need to add a column to a table using code. The following works, but only for a new table. How should I change this to alter an existing table? Dim strConn Dim Catalog As New...
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...
5
by: Wayne Wengert | last post by:
I am using VB ASP.NET. In my page I convert an uploaded XML file to a dataset as follows: Dim ds1 As DataSet = New DataSet ds1.ReadXml(strPathName, XmlReadMode.Auto) Now I want to append...
5
by: Tim | last post by:
Hi, I am trying to move a datacolumn in a datatable. What I have tried so far is to create a new datacolumn set it equal to the one I want to remove and then remove it, add another column and...
1
by: orabalu | last post by:
Hi Guys, I have table called A it contains 2 columns x,y . And I have Target table it is also contains M and N. I do have one Audit table contains last_load date and other columns. Intiailly I...
1
by: Milan Mehta | last post by:
I am a newbie to MS Access. Please bear with me for such question. I have a table1 in Database1. I need to append data from table2 in Database2 to table1 of Databases1. How can I do that ? TIA...
1
by: Bull | last post by:
Hi, Is there a way (besides Case or IIf), to type a value into field1 and have that value added to the value inside a memo or text field? Example: memo/text field has: hello in field1 i...
1
by: koyanpaing | last post by:
Hi everyone, I would like to know about how to insert data into existing table row. here is my javascript file. function addDataToRows(tableID,noOfRows,data) { var table =...
1
by: Sorin | last post by:
i have a database on sql server 2008 with one table. The data in that table comes form an excel file. how do i append the data in the excel to the existing sql table? how can i make the process...
10
by: timleonard | last post by:
I am trying to update some existing database tables by inserting some new fields in a set order within the existing table. The issue I am having is it inserts the new field at the existing position...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
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)...
1
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....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.