Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

LastName data replaced by FirstName after Anaylize Excel feature

Discussion in 'Information Technology' started by maxdiller2007, Jul 28, 2006.

  1. maxdiller2007

    maxdiller2007
    Expand Collapse
    Guest

    Recently I reqested my home office to open our Access database and use the
    "Anaylize with Excel" feature (so our office mgr could email me a copy of the
    database in Excel).

    To her horror the next time she opened Access the entire database (5500
    names) had all of the LastNames replaced with First Names! In other words we
    now have an entire Access database with two fields of FIRST NAMES as the LAST
    NAMES have vanished into thin air! Any suggestions on how to recover data
    (i.e. maybe it is still in Access) would be much appreciated!
     
  2. Loading...


  3. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    backup?

    Pieter

    "maxdiller2007" <maxdiller2007@discussions.microsoft.com> wrote in message
    news:1EFE2F1E-F967-4BCA-863F-256E63F4F49C@microsoft.com...
    > Recently I reqested my home office to open our Access database and use the
    > "Anaylize with Excel" feature (so our office mgr could email me a copy of
    > the
    > database in Excel).
    >
    > To her horror the next time she opened Access the entire database (5500
    > names) had all of the LastNames replaced with First Names! In other words
    > we
    > now have an entire Access database with two fields of FIRST NAMES as the
    > LAST
    > NAMES have vanished into thin air! Any suggestions on how to recover
    > data
    > (i.e. maybe it is still in Access) would be much appreciated!
     
  4. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    maxdiller2007 wrote:
    > Recently I reqested my home office to open our Access database and
    > use the "Anaylize with Excel" feature (so our office mgr could email
    > me a copy of the database in Excel).
    >
    > To her horror the next time she opened Access the entire database
    > (5500 names) had all of the LastNames replaced with First Names! In
    > other words we now have an entire Access database with two fields of
    > FIRST NAMES as the LAST NAMES have vanished into thin air! Any
    > suggestions on how to recover data (i.e. maybe it is still in Access)
    > would be much appreciated!


    Do you still have a copy of that Excel file?

    BTW just sending the information to Excel could not have done the deed.
    Something else happened.

    --
    Joseph Meehan

    Dia duit
     
  5. maxdiller2007

    maxdiller2007
    Expand Collapse
    Guest

    Re: LastName data replaced by FirstName after Anaylize Excel featu

    yes....I do have a copy of the Excel file

    "Joseph Meehan" wrote:

    > maxdiller2007 wrote:
    > > Recently I reqested my home office to open our Access database and
    > > use the "Anaylize with Excel" feature (so our office mgr could email
    > > me a copy of the database in Excel).
    > >
    > > To her horror the next time she opened Access the entire database
    > > (5500 names) had all of the LastNames replaced with First Names! In
    > > other words we now have an entire Access database with two fields of
    > > FIRST NAMES as the LAST NAMES have vanished into thin air! Any
    > > suggestions on how to recover data (i.e. maybe it is still in Access)
    > > would be much appreciated!

    >
    > Do you still have a copy of that Excel file?
    >
    > BTW just sending the information to Excel could not have done the deed.
    > Something else happened.
    >
    > --
    > Joseph Meehan
    >
    > Dia duit
    >
    >
    >
     
  6. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Re: LastName data replaced by FirstName after Anaylize Excel featu

    maxdiller2007 wrote:
    > yes....I do have a copy of the Excel file
    >
    > "Joseph Meehan" wrote:
    >


    Hopefully you can use that Excel file to restore the lost data.

    --
    Joseph Meehan

    Dia duit
     

Share This Page