Can I use a form to import data from excel???

[marlun]

Hi! I wonder if there is a possibility to use a form to import data from an excel-file into an existing table. If it's possible I would like to use a browse field/button, or is the only way throug the FILE in the MENU, and then get external data???

Would appreciate any help...

/marlun

 

[grnzbra]

use the command TransferSpreadsheet

 

[KornGeek]

Check out thread702-121993 for a way to open a browse window.

Use this to get the file name, and then use grnzbra's suggestion of using the TransferSpreadsheet command to handle the import.