Welcome to SPN

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

Sign Up Now!

Importing Data - Access 97

Discussion in 'Information Technology' started by Bob Watson, Nov 17, 2005.

  1. Bob Watson

    Bob Watson
    Expand Collapse
    Guest

    I have two databases DB1 DB2


    DB2 has the same fields as DB1 plus a few more.
    Same field names, same types, same sizes.


    There is a table in each of them named STATION.

    I want to bring all the records from DB1.STATION into
    DB2.STATION.

    First I deleted all the records from DB2.STATION - no problem.
    Then I tried to

    FILE -> GetExternalData -> Import

    and pointed to DB1.STATION table ... then clicked IMPORT

    But nothing happened. Can someone tell me how to accomplish
    this task??

    TIA,
    Bob
     
  2. Loading...


  3. Phillip Windell

    Phillip Windell
    Expand Collapse
    Guest

    Rename the table "station" that you don't need anymore to something else.
    Them go to the other DB with the table you actually want and "export" the
    table to the other DB.

    When you are sure you no longer need the table that was renamed you can
    delete it.

    --
    Phillip Windell [MCP, MVP, CCNA]
    www.wandtv.com
    -----------------------------------------------------
    Understanding the ISA 2004 Access Rule Processing
    http://www.isaserver.org/articles/ISA2004_AccessRules.html

    Microsoft Internet Security & Acceleration Server: Guidance
    http://www.microsoft.com/isaserver/techinfo/Guidance/2004.asp
    http://www.microsoft.com/isaserver/techinfo/Guidance/2000.asp

    Microsoft Internet Security & Acceleration Server: Partners
    http://www.microsoft.com/isaserver/partners/default.asp
    -----------------------------------------------------



    "Bob Watson" <RMWatson3rd@bellsouth.net> wrote in message
    news:bfKef.20842$xK1.8385@bignews7.bellsouth.net...
    >
    > I have two databases DB1 DB2
    >
    >
    > DB2 has the same fields as DB1 plus a few more.
    > Same field names, same types, same sizes.
    >
    >
    > There is a table in each of them named STATION.
    >
    > I want to bring all the records from DB1.STATION into
    > DB2.STATION.
    >
    > First I deleted all the records from DB2.STATION - no problem.
    > Then I tried to
    >
    > FILE -> GetExternalData -> Import
    >
    > and pointed to DB1.STATION table ... then clicked IMPORT
    >
    > But nothing happened. Can someone tell me how to accomplish
    > this task??
    >
    > TIA,
    > Bob
    >
    >
     
  4. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Wed, 16 Nov 2005 12:48:06 -0500, "Bob Watson"
    <RMWatson3rd@bellsouth.net> wrote:

    >First I deleted all the records from DB2.STATION - no problem.
    >Then I tried to
    >
    > FILE -> GetExternalData -> Import
    >
    >and pointed to DB1.STATION table ... then clicked IMPORT
    >
    >But nothing happened. Can someone tell me how to accomplish
    >this task??


    The simplest way would be to look in your Tables window - you should
    now have a table named STATION1 which is your imported table (it added
    the 1 to prevent a name clash).

    Delete STATION and rename STATION1 and reestablish any relationships.

    OR... delete STATION1 (if it in fact exists); and use File... Get
    External Data... Link to link to DB2.STATION. Create an Append query
    based on the linked table (which again will probably be named
    STATION1) and append the data to STATION.

    John W. Vinson[MVP]
     
  5. Bob Watson

    Bob Watson
    Expand Collapse
    Guest

    Thanks ... I likely did not explain myself very well.

    I have a new structure in DB1.Station and the
    good data in DB2.Station ... I want the "good data"
    into the new structure. I ended up
    1 opening the "new structure table" and Edit->SelectAll->Delete
    2 opening up the "good data table" and Edit->SelectAll->Copy
    3 opening up the "new structure table" and Edit->Paste Append

    It was awkard, but worked fine.

    At times I have an old "dBase mindset" ... that would have been
    a AppendFrom <filename> in dBase.

    Thanks,
    Bob



    "John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
    news:t01nn19qr4v2vmort6kgmq3si3jis3jkih@4ax.com...
    > On Wed, 16 Nov 2005 12:48:06 -0500, "Bob Watson"
    > <RMWatson3rd@bellsouth.net> wrote:
    >
    >>First I deleted all the records from DB2.STATION - no problem.
    >>Then I tried to
    >>
    >> FILE -> GetExternalData -> Import
    >>
    >>and pointed to DB1.STATION table ... then clicked IMPORT
    >>
    >>But nothing happened. Can someone tell me how to accomplish
    >>this task??

    >
    > The simplest way would be to look in your Tables window - you should
    > now have a table named STATION1 which is your imported table (it added
    > the 1 to prevent a name clash).
    >
    > Delete STATION and rename STATION1 and reestablish any relationships.
    >
    > OR... delete STATION1 (if it in fact exists); and use File... Get
    > External Data... Link to link to DB2.STATION. Create an Append query
    > based on the linked table (which again will probably be named
    > STATION1) and append the data to STATION.
    >
    > John W. Vinson[MVP]
     
  6. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Wed, 16 Nov 2005 14:39:03 -0500, "Bob Watson"
    <RMWatson3rd@bellsouth.net> wrote:

    >Thanks ... I likely did not explain myself very well.
    >
    >I have a new structure in DB1.Station and the
    >good data in DB2.Station ... I want the "good data"
    >into the new structure. I ended up
    > 1 opening the "new structure table" and Edit->SelectAll->Delete
    > 2 opening up the "good data table" and Edit->SelectAll->Copy
    > 3 opening up the "new structure table" and Edit->Paste Append
    >
    >It was awkard, but worked fine.
    >
    >At times I have an old "dBase mindset" ... that would have been
    >a AppendFrom <filename> in dBase.


    Well, dBase "databases" are in separate files, unlike Access tables.

    INSERT INTO Station
    SELECT * FROM [Station] IN "E:\Path\DB2";

    would probably have worked.

    John W. Vinson[MVP]
     
  7. Bob Watson

    Bob Watson
    Expand Collapse
    Guest

    Yes sir, they are ... Exactly how do I give it that
    SQL command?? Where do I find that window ?? in '97??
    I want to "speak a command" and all I can find are
    drag-and-drop sort of objects.

    Thanks,
    Bob


    "John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
    news:003nn1tt32gv8h1r4t8766udvpgvnm3qcj@4ax.com...
    > On Wed, 16 Nov 2005 14:39:03 -0500, "Bob Watson"
    > <RMWatson3rd@bellsouth.net> wrote:
    >
    >
    > Well, dBase "databases" are in separate files, unlike Access tables.
    >
    > INSERT INTO Station
    > SELECT * FROM [Station] IN "E:\Path\DB2";
    >
    > would probably have worked.
    >
    > John W. Vinson[MVP]
     
  8. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    When you go into the query builder, there's a SQL View option (under the
    View menu)

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Bob Watson" <RMWatson3rd@bellsouth.net> wrote in message
    news:8gMef.1343$cd1.839@bignews5.bellsouth.net...
    > Yes sir, they are ... Exactly how do I give it that
    > SQL command?? Where do I find that window ?? in '97??
    > I want to "speak a command" and all I can find are
    > drag-and-drop sort of objects.
    >
    > Thanks,
    > Bob
    >
    >
    > "John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
    > news:003nn1tt32gv8h1r4t8766udvpgvnm3qcj@4ax.com...
    > > On Wed, 16 Nov 2005 14:39:03 -0500, "Bob Watson"
    > > <RMWatson3rd@bellsouth.net> wrote:
    > >
    > >
    > > Well, dBase "databases" are in separate files, unlike Access tables.
    > >
    > > INSERT INTO Station
    > > SELECT * FROM [Station] IN "E:\Path\DB2";
    > >
    > > would probably have worked.
    > >
    > > John W. Vinson[MVP]

    >
    >
     
  9. Phillip Windell

    Phillip Windell
    Expand Collapse
    Guest

    Did you see my post?

    --
    Phillip Windell [MCP, MVP, CCNA]
    www.wandtv.com
    -----------------------------------------------------
    Understanding the ISA 2004 Access Rule Processing
    http://www.isaserver.org/articles/ISA2004_AccessRules.html

    Microsoft Internet Security & Acceleration Server: Guidance
    http://www.microsoft.com/isaserver/techinfo/Guidance/2004.asp
    http://www.microsoft.com/isaserver/techinfo/Guidance/2000.asp

    Microsoft Internet Security & Acceleration Server: Partners
    http://www.microsoft.com/isaserver/partners/default.asp
    -----------------------------------------------------


    "Bob Watson" <RMWatson3rd@bellsouth.net> wrote in message
    news:8gMef.1343$cd1.839@bignews5.bellsouth.net...
    > Yes sir, they are ... Exactly how do I give it that
    > SQL command?? Where do I find that window ?? in '97??
    > I want to "speak a command" and all I can find are
    > drag-and-drop sort of objects.
    >
    > Thanks,
    > Bob
    >
    >
    > "John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
    > news:003nn1tt32gv8h1r4t8766udvpgvnm3qcj@4ax.com...
    > > On Wed, 16 Nov 2005 14:39:03 -0500, "Bob Watson"
    > > <RMWatson3rd@bellsouth.net> wrote:
    > >
    > >
    > > Well, dBase "databases" are in separate files, unlike Access tables.
    > >
    > > INSERT INTO Station
    > > SELECT * FROM [Station] IN "E:\Path\DB2";
    > >
    > > would probably have worked.
    > >
    > > John W. Vinson[MVP]

    >
    >
     
  10. Bob Watson

    Bob Watson
    Expand Collapse
    Guest

    Yes, I did - Thanks


    "Phillip Windell" <@.> wrote in message
    news:e0VgM0v6FHA.2012@TK2MSFTNGP14.phx.gbl...
    > Did you see my post?
    >
    > --
    > Phillip Windell [MCP, MVP, CCNA]
    > www.wandtv.com
    > -----------------------------------------------------
    > Understanding the ISA 2004 Access Rule Processing
    > http://www.isaserver.org/articles/ISA2004_AccessRules.html
    >
    > Microsoft Internet Security & Acceleration Server: Guidance
    > http://www.microsoft.com/isaserver/techinfo/Guidance/2004.asp
    > http://www.microsoft.com/isaserver/techinfo/Guidance/2000.asp
    >
    > Microsoft Internet Security & Acceleration Server: Partners
    > http://www.microsoft.com/isaserver/partners/default.asp
    > -----------------------------------------------------
    >
    >
    > "Bob Watson" <RMWatson3rd@bellsouth.net> wrote in message
    > news:8gMef.1343$cd1.839@bignews5.bellsouth.net...
    >> Yes sir, they are ... Exactly how do I give it that
    >> SQL command?? Where do I find that window ?? in '97??
    >> I want to "speak a command" and all I can find are
    >> drag-and-drop sort of objects.
    >>
    >> Thanks,
    >> Bob
    >>
    >>
    >> "John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
    >> news:003nn1tt32gv8h1r4t8766udvpgvnm3qcj@4ax.com...
    >> > On Wed, 16 Nov 2005 14:39:03 -0500, "Bob Watson"
    >> > <RMWatson3rd@bellsouth.net> wrote:
    >> >
    >> >
    >> > Well, dBase "databases" are in separate files, unlike Access tables.
    >> >
    >> > INSERT INTO Station
    >> > SELECT * FROM [Station] IN "E:\Path\DB2";
    >> >
    >> > would probably have worked.
    >> >
    >> > John W. Vinson[MVP]

    >>
    >>

    >
    >
     

Share This Page