There are two ways of doing it:
1. In Access, point to Get External Data on the File menu, and click either Import or Link Tables.
2. In the dialog box that appears, browse to and select your Excel file, and click either Import or Link.
3. On the first page of the wizard, select the First Row Contains Column Headings check box, and then click Next. Be sure to select the check box only if your data contains column headings in the first row.
And the second is by using VBA and writing a script to export data from Excel to Access.