How to use excel fields in access forms

[sunilvedula]

Hi ,

I am trying to use an excel file which i linked to access. I want to use those fields in a form. How do i do that???? when i try declaring it says that "tbl" is not a mdb. what do i do????

 

[edtab]

If you had done you link correctly, the file should behave like
an access table and you should be able to use it as such,
including creating a form.

I suspect that the link was not done properly.
Open your db and on the tables tab, click on the
linked excel file and see whether it opens or not.
If not, then try to relink it again.