How do I import specific records between Access databases?

[Guest]

I am attempting to import only specific records from one Access database to a
new one. Is this possible?

 

[aaron.kempf]

if you were using SQL Server and Access Data Projects; it would be
super easy.

Insert Into DBONE.dbo.MyTable
Select * from DBTWO.dbo.MyTable

Try doing _THAT_ in Access MDB lol

-Aaron

 

[Guest]

I suppose anything is possible....but if it is a one time task - I would make
a new table....and just copy them into a new table within the same db....and
then import that new table.

 

[Guest]

Thanks - it's a bit more complicated than that though. I have 565 individual
membership records that need to be imported into a new table upon receipt of
renewals, which are coming in at different times. I do appreciate your
feedback. Even if this could be done in Excel, that would help more than
typing these records in individually.

 

[Guest]

Thanks - it's a bit more complicated than that though. I have 565 individual
membership records that need to be imported into a new table upon receipt of
renewals, which are coming in at different times. I do appreciate your
feedback. Even if this could be done in Excel, that would help more than
typing these records in individually.

 

[aaron.kempf]

ROFL

and what.. copy and paste?

ROFL

SQL Server has _REAL ENTERPRISE LEVEL TOOLS_ for doing this; it is
called 'ETL'

these blueheads around here-- that found it too difficult to learn ADO
and TSQL lol-- they're full of crap and I reccomend changing to
microsoft.public.sqlserver

 

[Guest]

can you isolate these 565 via a query? if so then you can do an AppendQuery
or MakeTableQuery

 

[Guest]

I'll try that -- thanks again

can you isolate these 565 via a query? if so then you can do an AppendQuery
or MakeTableQuery

 

[Guest]

I'll try that -- thanks again

can you isolate these 565 via a query? if so then you can do an AppendQuery
or MakeTableQuery

 

[John Vinson]

I am attempting to import only specific records from one Access database to a
new one. Is this possible?

Certainly, several ways.

Probably simplest: open the new database. Use File... Get External
Data... Import; import the table, selecting the "design mode only"
option to create a new, empty table in the new database.

Then use File... Get External Data... Link to link to the same table.
Access will put a numeral 1 after the name since you can't have two
tables with the same name. Then create an Append query based on the
linked table, applying whatever criteria you wish to select the
desired records. Append to the new table, and run the query by
clicking the ! icon. If it's a one-shot operation, you can then delete
the link to the table.

John W. Vinson[MVP]

 

[John Vinson]

Thanks - it's a bit more complicated than that though. I have 565 individual
membership records that need to be imported into a new table upon receipt of
renewals, which are coming in at different times. I do appreciate your
feedback. Even if this could be done in Excel, that would help more than
typing these records in individually.

ummmmm....

WHY???

Sounds like you're storing the exact same data in two different
tables, depending on whether data exists in another table (renewals).

This is neither necessary nor is it good design.

I'd really suggest just keeping all the membership data in one table
(565 records is TINY, if you had 565,000 you might need to worry about
size); just use a Query to distinguish renewed from non-renewed
members.

John W. Vinson[MVP]