How do I move data in one column up one row

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

onemulligan - 31 May 2005 01:09 GMT

I am trying to make a database from another program. I copied the First
Name, Last Name, and Address. The Adresses' went into the column leaving a
blank cell at the top. I need to remove that cell so all the addresses' will
move up one row in order to match the first and last name. Hope I made this
easy to understand. Can someone tell me how to do this? Thank you

Reply to this Message

MacDermott - 31 May 2005 01:28 GMT

One fairly easy method would be to export the entire table to Excel (File -
Export).
Remove the unwanted cell, selecting "Move Up" when prompted.
Verify that the rows are now aligned as you desire.
Then import the whole thing back into Access.

> I am trying to make a database from another program. I copied the First
> Name, Last Name, and Address. The Adresses' went into the column leaving a
> blank cell at the top. I need to remove that cell so all the addresses' will
> move up one row in order to match the first and last name. Hope I made this
> easy to understand. Can someone tell me how to do this? Thank you

Reply to this Message

onemulligan - 31 May 2005 03:34 GMT

Thank you so much. I did what you said and it worked :)) I must have tried
for about an hour in access to do it and finally gave up and wrote this note.
I really appreciate your help and making it easy to do.

> One fairly easy method would be to export the entire table to Excel (File -
> Export).
[quoted text clipped - 10 lines]
> this
> > easy to understand. Can someone tell me how to do this? Thank you

Reply to this Message

John Vinson - 31 May 2005 01:39 GMT

>I am trying to make a database from another program. I copied the First
>Name, Last Name, and Address. The Adresses' went into the column leaving a
>blank cell at the top. I need to remove that cell so all the addresses' will
>move up one row in order to match the first and last name. Hope I made this
>easy to understand. Can someone tell me how to do this? Thank you

Access tables do not have "cells". Access Tables do not have "a first
record" or "a last record" or "a top" in any useful way.

Your Table apparently contains a record with Null in the Address
field, and all the other records have an incorrect address (the
address pertaining to a different record). I'd really suggest running
an Update query to update the Address field to NULL for all records,
and try again copying and pasting - or, better, running an update
query - to insert the correct addresses. There's no way to "move an
address up" because there is no "up" or "down".

John W. Vinson[MVP]

Reply to this Message