Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Roanoke, Virginia, USA
    Thanked 0 Times in 0 Posts
    I have a text field in tblCustomer named CompanyName. We are having trouble with multiple spellings of company names so I think I need to create a new tblCompanyName.

    Is there a way to copy the data in the CompanyName field in tblCustomer to a new company name field in tblCompanyName? The plan would be to scrub the data in the CompanyName field in tblRental and then hopefully copy it to tblCompanyName.


  2. #2
    Join Date
    Aug 2009
    Thanked 0 Times in 0 Posts
    You could try exporting it to excel and then importing it back into the new destination table.

    - Go to the ribbon tab "External Data"
    - Click on the export to excel button (save it somewhere you can find the file, probably desktop)
    - Manipulate the data however you need to.
    - Make sure the first row in the excel sheet matches the column names in your access table
    - Go into access and back to the "External Data" tab.
    - Click import from excel button
    - Select the "append records to table" option and load them up.
    - The records should appear in access as they did in excel before the import.

    *Note - make sure that all of the columns on the excel document are ones that you actually want to import, if you don't want to import them all either name the range that you want into access, put it on a new sheet, or put the data into a new document.

    Good luck!


    {Edit - I'm assuming that you're using access 2007, if not the directions will be different!}

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts
    You can use an append query to add data from one table to another one.

Posting Permissions

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