microsoft+access+training+course - Macro to import external data

Resolved · Low Priority · Version Standard

Tue 18 Sep 2007, 15:08 Delegate Satoshi said...

Satoshi has attended:
Access Advanced course
Access VBA course

Macro to import external data

I have tried to import external data (table) from another Microsoft Access Database by using TransferDatabase action. I have entered parameters (transfer type, database type, database name...etc) correctly, and it works ok when I try to import a table from .mdb Access file but it doesn't when I do the same from .adp Access file.

I could import tables from .adp Access file manually but I need to automate this step using macro or VBA.

Is there any special way when import a table from .adp? or is it not possible by using macro or VBA? Please help, appreciate your comment.

Fri 21 Sep 2007, 16:22 Edited on Fri 21 Sep 2007, 16:23 Trainer Richard said...

RE: Macro to import external data

The Link transfer type is not supported for Access projects (.adp).

http://msdn2.microsoft.com/en-us/library/bb177398.aspx

Mon 24 Sep 2007, 11:19 Delegate Satoshi said...

RE: Macro to import external data

Thanks for the link. However, in the first sentence of the article, it says..

"You can use the TransferDatabase action to import or export data between the current Access database (.mdb or .accdb) or Access project (.adp) and another database".

I've seen this comment but still doesn't work, this is why I am asking this question on this forum.

I would like to ask anyone once again, "is there any special way to import data from .adp file using Macro, TransferDatabase action?"

I would appreciate any comment. Thank you.

Fri 28 Sep 2007, 10:48 Trainer Richard said...

RE: Macro to import external data

In the TRANSFER TYPE, what option are you selecting when you want to bring in information from a ADP file?

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Access tip:

Related tables

When you have related tables such as Customers and their Orders, the Customer table is the Primary table.

Open the Customers table in datasheet view and go to the Home Tab and Records group. Click on the More option and choose Subdatasheet and then click on Subdatasheet again. Now choose the related table (Orders) and click ok.

Now you can click the + symbol by each company to show the related orders.

View all Access hints and tips