Hi I have an excel spreadsheet with 8500 records. I have given you a sample file of only 25 records and the format it comes to me in. I want to open it in access and have the fields populate when I open the excel file in Access and be able to sort on any field.
The body field in the Excel has important the info I need to show up in access file to search and sort on
Below are the fields I need to populate in access from the excel file I provided.
Info From Body Field Needed
Let me know the charge to create an access report that will pull the data from this excel sheet.