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