Results 1 to 3 of 3
  1. #1
    Join Date
    May 2014
    Posts
    2

    Unanswered: How to copy data from one column to other using query.

    Hi All,

    I am having excel file where it contains multiple sheets (Sheet 1 , Sheet 2, Sheet 3 etc).

    When i import the excel to Access, File contains one Value in Cell A1 in Sheet 1 and i need to copy the same date to all the Values under Column A and need to copy the same data to all other sheets for Column A.

    Please advise how to write the query for this one.

    Thanks.

  2. #2
    Join Date
    May 2014
    Posts
    2

    How to copy data from one column to other using query.

    Hi All,

    I am having excel file where it contains multiple sheets (Sheet 1 , Sheet 2, Sheet 3 etc).

    When i import the excel to Access, File contains one Value in Cell A1 in Sheet 1 and i need to copy the same date to all the Values under Column A and need to copy the same data to all other sheets for Column A.

    Please advise how to write the query for this one.

    Thanks.

  3. #3
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    If I understand what you're asking for (not sure):
    Code:
    UPDATE TableName SET TableName.Column2 = TableName.Column1;
    Have a nice day!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •