News

How to get the data into Power Query We’ll work with a simple Excel sheet with a few delimited strings in a Table named TableCustomerID.
Launch Excel and open the spreadsheet you wish to load into Access. Verify that the spreadsheet's column names match the Access table's field names.