Access
Import excel data to access data
If we have a excel data, we can just import it to access data without typing it again
1)File>Get External Data>import
2)At the Files of type, we choose Microsoft Excel. Then we will see the excel file. We click it and then click Import.
3)Click next
4)Remember to tick First Row Contains Column Headings. Then we click Finish
5)Done!
export access data to excel data
In the same way, we export access data to excel data.
1)File>Export
2)At Save as Type, we choose Microsoft Excel, then click Export!
