import with macro's command

[wizardoz]

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

[Gintaras]

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.