Import Excel file into form

  • Thread starter Thread starter Swapna
  • Start date Start date
S

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
 
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.
 
Back
Top