Uploading excel data into Access in a form which is been created.

[Kapil5360079]

Hi Friends,
Please could you help me on the below queries.


I m using access 2007. In access there is a form designed. I want to import the excel data into that form. The designed form is basically a Macro. So I just need to import the data from excel. Please could u help???

[alansidman]

First of all, Forms do not hold data. They are used to input data into tables or to view data that is contained in either tables or queries.

You want to import Excel data into a table. In Access 2007, on the ribbon, select external data and then select import and finally, excel. Follow the wizard to import your data into Access.

Alan