Can User Input Be Used in a TransferDatabase MACRO ???

  • Thread starter kev100 via AccessMonster.com
  • Start date
K

kev100 via AccessMonster.com

I posted a question similar to this in the Import/Linking forum....and
received a possible VBA coding solution.

This may be the more appropriate forum and am posting here, just in case.
Since I'm not real familiar with VBA coding...I'm hoping there may be some
little-known feature in Access that makes this possible...

I've set up a Macro to Import a non-Access table into an Access table.

In the TransferDatabase macro...there is a field for the source table name.
I currently have the exact name of the source table..and it works fine.

However, I'm needing to prompt the User for the NAME of the Source table that
is being imported.

In other words....is it possible to use some type of user input for that
field of the Macro...rather than it being fixed?

There are several tables....any one of which the user may need to import
depending on the task at hand.

Is it possible to use some sort of paramater input variable in the source
table field?

Something like...
Source: [Enter Table Name Suffix:] (?)

I have tried the above syntax....but it does not work...I only used it to try
to illustrate what is needed.

Thanks very much.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

transferdatabase in new 2007 1
in Access 2007-TransferDatabase action will not work. 0
Use Paramater Input with an Table Import MACRO? 3
What Happend to 'TransferDatabase' in Access Macros 2007 1
Create a Macro and Import into Access to RUN 2
Using a parameter in a transferdatabase macro 3
TransferDatabase 4
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Top