Automating the import process

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'd like to add a button to a form that automates the "File - Get External
Data - Import" process to import an excel file... any suggestions?

Thanks
 
Look in VBA Help for the TransferSpreadsheet method or action.
If you use VBA, you will use the method version and for a Macro, you will
use the action.
 
Well that was too easy... thanks!

Klatuu said:
Look in VBA Help for the TransferSpreadsheet method or action.
If you use VBA, you will use the method version and for a Macro, you will
use the action.
Click to expand...
 

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

Automate "Get External Data" over HTTP with a BasicAuth protectedressource 3
connect to Progress SQL92 Driver using VBA 2
Automating Excel Data Import 8
Is there a way to Automate imports? 6
adding a field to access db thru import 1
Import spreadsheet with modified date 1
Automate Import/Update of Database 2
Importing Text Files Into Access 1

Back
Top