Assume I have data like so:

```
+------+------+------+------+
| Col1 | Col2 | Col3 | Col4 |
+------+------+------+------+
| a    | b    | x    | y    |
+------+------+------+------+

```

I wish to split it after a certain column to achieve something like this:

```
+------+------+
| Col1 | Col2 |
+------+------+
| a    | b    |
| x    | y    |
+------+------+

```

What would be the easiest way to achieve this? I am currently forced to do this in an old MS Access database with a connection to the SQL server. Thoughts?