microsoft+access+training+course - macro import external data
Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft+access+training+course - Macro to import external data

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

resolvedResolved · Low Priority · Version Standard

Tue 18 Sep 2007, 15:08 replyReply 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.


For upcoming training course dates see: Pricing & availability

Fri 21 Sep 2007, 16:22 Edited on Fri 21 Sep 2007, 16:23 replyReply 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 replyReply 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 replyReply 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?

 

Access tip:

Hiding rows and columns

To hide a column or row in Access, you need to minimise the column or row. This can be done by placing your mouse on the right edge of a column, wait for the mouse to change to a double aroow and then drag to minimise the column

View all Access hints and tips



Access training London
Course rating:
4.8 stars - based on 4042 reviews
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Google+ · Facebook · Twitter · LinkedIn · Pinterest

2nd Floor, CA House, 1 Northey Street
Limehouse Basin, London, E14 8BT
United Kingdom