Importing Data - Access 97

[Bob Watson]

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

 

[Phillip Windell]

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

 

[John Vinson]

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]

 

[Bob Watson]

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]

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]

 

[Bob Watson]

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

 

[Douglas J Steele]

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

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

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

On Wed, 16 Nov 2005 14:39:03 -0500, "Bob Watson"


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]

 

[Phillip Windell]

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
-----------------------------------------------------

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

On Wed, 16 Nov 2005 14:39:03 -0500, "Bob Watson"


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]

 

[Bob Watson]

Yes, I did - Thanks

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
-----------------------------------------------------

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

On Wed, 16 Nov 2005 14:39:03 -0500, "Bob Watson"


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]