Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
import with macro's command
#1
Hi, I would like to know how do I create a command that import a certain file (12.xls) to a table in access using macro's command

Thanks,Elen
#2
Try to record.

Here is my recorded macro, with comments:
Code:
Copy      Help
act win("Microsoft Access" "OMain")
'A{fgi} ;;menu File -> Get External Data -> Import
5 win("Import" "bosa_sdm_Mso96") ;;wait for Import dialog
'Sbook1.xlsY ;;type filename in Import dialog and press Enter
5 win("Import Spreadsheet Wizard" "OFormPopup") ;;wait for wizard
'Af ;;press Finish button
5 win("Import Spreadsheet Wizard " "#32770") ;;wait for message box
'Y ;;Enter

Of course, in your case it will be different.


Forum Jump:


Users browsing this thread: 1 Guest(s)