Can I Import Excel File into Access Form?

[chleng]

Hi all.

I know that we need to have the table in MS Access before we can create the Form in MS Access but I wish to know is there any means that we can import the data from MS Excel to the Form in MS Access bypassing the table in Access?



Thanks.

[Robeen]

You can click on External Data -> Excel -> Link to the data source by creating a linked table.
That will give your Access database the ability to use that spreadsheet in a Form in the same way as you would use a Table as the data source for a Form.
I hope this helps!