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
|
|||
|
|||
Copying Data from 1 field to multiple fields?
Does anyone know of a way of copying data in 1 field in a
row to other multiple blank fields in a large table? I have filtered records and want to copy a particular bit of data to thousands of rows, where this field is presently blank. I have tried everything to no avail. Have looked at Access help and spoken to the Office IT 'guru'. Have tried using the mouse, keyboard and also 'find and replace'. I know I could export the table into excel, copy this info easily and then import back into the Access DB. However as I have to do this exercise for numerous DBs I would rather not. There has to be a way surely? Frustrated and Fed Up! Frustrated |
#2
|
|||
|
|||
Copying Data from 1 field to multiple fields?
Could you post to this thread the releavnt table layouts
indicating the location of the source data and the destination columns. Gerald Stanley MCSD -----Original Message----- Does anyone know of a way of copying data in 1 field in a row to other multiple blank fields in a large table? I have filtered records and want to copy a particular bit of data to thousands of rows, where this field is presently blank. I have tried everything to no avail. Have looked at Access help and spoken to the Office IT 'guru'. Have tried using the mouse, keyboard and also 'find and replace'. I know I could export the table into excel, copy this info easily and then import back into the Access DB. However as I have to do this exercise for numerous DBs I would rather not. There has to be a way surely? Frustrated and Fed Up! Frustrated . |
#3
|
|||
|
|||
Copying Data from 1 field to multiple fields?
"Ruth Whitelaw" wrote in
: I have filtered records and want to copy a particular bit of data to thousands of rows, where this field is presently blank. UPDATE MyTable SET MyField = "Something" WHERE MyField IS NULL Hope that helps Tim F |
#4
|
|||
|
|||
Copying Data from 1 field to multiple fields?
It sounds lots as if your database has not been properly normalized. If you
are not familiar with the terms "normalized", "primary key" and "foreign key", you have some study to do! Start here for a dry, but instructive read: http://support.microsoft.com/support...es/Q100139.ASP HTH, TC "Ruth Whitelaw" wrote in message ... Does anyone know of a way of copying data in 1 field in a row to other multiple blank fields in a large table? I have filtered records and want to copy a particular bit of data to thousands of rows, where this field is presently blank. I have tried everything to no avail. Have looked at Access help and spoken to the Office IT 'guru'. Have tried using the mouse, keyboard and also 'find and replace'. I know I could export the table into excel, copy this info easily and then import back into the Access DB. However as I have to do this exercise for numerous DBs I would rather not. There has to be a way surely? Frustrated and Fed Up! Frustrated |
Thread Tools | |
Display Modes | |
|
|