Split strings from table by space into separate columns
<p>I process tables in MS ACCESS 2016 and I have one column in a table which is text (string) like this example: D1 na 256km směr Břeclav. </p>

<p>I need to split that text into separate columns for every word so I can prepare data to delete some words and so on. I have already tried some examples in VBA for Access but it didn't work.</p>

<p>I need to Split them. Does anybody know how? The Split function doesn't work in an SQL query, and I don't know how to properly do it in VBA. </p>