Exporting Access to Access

[cotri]

I am trying to export information from an Access database to another Access database and the fields are not named exactly the same in each database. I have set up a query that is pulling selected records and the resulting records are what I would like to export. I have limited experience exporting info using csv but it has been awhile and I’m hoping that will not be necessary here. If somebody has samples of two databases sharing data that would be ideal. Thanks for the help.

[ConneXionLost]

Hi cotri,

Connect the two databases via the source table:

File > Get External Data > Link Tables...

then use your append query to transfer the records from one table to the next.

Cheers,

[cotri]

Hi cotri,

Connect the two databases via the source table:

File > Get External Data > Link Tables...

then use your append query to transfer the records from one table to the next.

Cheers,

I must be doing something wrong here. I set up 2 simple databases to test. What I’m trying to do is take the results of a query in Database 1 and add those records to a table in Database 2. These records will be new records in Database 2 and when imported don't have ID fields. The field names to not match exactly. When I tried to File>Get External Data>Link tables I do not have the option to import queries. In Database 2 I tried File>Get External Data> Import and selected Database1 and I get a window “import objects” and I am able to select “Query” and I can select the query from Database 1 that I want to import. I now see the query from Database 1 in "Queries" in Database 2 and open it in “Design view” and under “Query Type” select “Append” and get the window “Append”. I select “Current Database” and under “Table Name” select the table in Database 2. For each field I fill in the appropriate “Append to” with its mating field. When I run the query I get an error “The Microsoft Jet database cannot find the input table or query ‘Table 1’. Make sure it exists and that its name is spelled correctly”. The name of the query it is pulling data from is not ‘Table 1” it is “Table 1 Query”. I’m guessing that part of the problem but I’m not able to proceed. I am trying to attach both databases here. Thanks again for any help.

[ConneXionLost]

Take smaller steps.

In Database 1, convert your query to a Make-Table query (or create a new query), and make a table with the desired records in Database 1.

In Database 2, link to the table you just created using File>Get External Data>Link tables.

Now create an append query to copy the records from the linked table to the table you want to keep the records.

Cheers,

[cotri]

Take smaller steps.

In Database 1, convert your query to a Make-Table query (or create a new query), and make a table with the desired records in Database 1.

In Database 2, link to the table you just created using File>Get External Data>Link tables.

Now create an append query to copy the records from the linked table to the table you want to keep the records.

Cheers,

That did the trick. Thanks for all the help