Using the Text to Columns Tool One way to split data into multiple columns in Microsoft Excel is to use the built-in Text To Columns tool. This method is handy if you prefer to work in a dialog ...

If you come across a table on the web or in another source that you want to import into Excel, there's an import feature that does the work for you.

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.