Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft+access+training+course - Macro to import external data
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
microsoft+access+training+course - Macro to import external data
Resolved · Low Priority · Version Standard
Reply Tue 18 Sep 2007, 15:08Delegate 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.
For upcoming training course dates see: Pricing & availability
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
Reply Mon 24 Sep 2007, 11:19Delegate 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.
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?
|