Import Excel file into form

[Swapna]

Hi there,
I imported a excel spread sheet into a form in Access.
In future if the file has additional data, how can the
data in the excel file be updated in Access.

Thanks and Regards
Swapna

 

[Guest]

hi,
data resides in tables not forms. the table is probably
bound to the form.
but a suggestion. if the data in the excel file is
changing, you might be better of in linking to the excel
file instead of importing it. as a linked file it will
act just like an access table but will automaticly reflect
any changes made to the excel file.