microsoft+access+training+course - macro import external data


starstarstarstarstar Excellent

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

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:

Changing MS Programs Text Size

A handy way to increase or decrease the size of text in Microsoft Word, Microsoft PowerPoint, Microsoft FrontPage, or Microsoft Publisher, first, select the text you want to resize.

Then, to increase the font size, press CTRL+SHIFT+>.

To decrease the font size, press CTRL+SHIFT+<.

View all Access hints and tips