This is an extract from Microsoft Support:

"With Power Query (known as Get & Transform in Excel), you can import or connect to external data, and then shape that data, for example remove a column, change a data type, or merge tables, in ways that meet your needs. Then, you can load your query into Excel to create charts and reports. Periodically, you can refresh the data to make it up to date. Power Query is available on three Excel applications, Excel for Windows, Excel for Mac and Excel for the Web."

Kevin,
Thank you for your reply. I am actually trying to upload data from excel spreadsheet into Access, but have to do multiple data edits to match the data fields for type conversion, splits, etc.  I have looked at power query for this and also VBA or macros to speed up the process, but wonder if the same things could be achieved in Access. The source spread sheet is updated periodically so this is a repeated append process.   What is the best tool to use, VBA, Power Query, or Access queries?