You have a few options.

1. Looking at your image the data looks like fixed width. You can manually edit the columns in access.

2. Import the data into excel and use the "text to columns" feature to split the fields. Then import to sql.

3. Edit the file with a text editor like notepad++ and insert a delimiter between columns.

4. Import the data into SQL into a single column and then use TSQL to parse/substring the data into different fields. It's not a nice job but its doable.

5. Go back to the source if this data and ask them to re-export with a delimeter, or grant query access so you can import data directly.

Looking at your image the data looks like it is fixed width. You have a few options. You could:

1. Manually edit the columns in access. (fixed width).

2. Import the data into excel and use the "text to columns" feature to split the fields. Then import to sql.

3. Edit the file with a text editor like notepad++ and insert a delimiter between columns.

4. Import the data into SQL into a single column and then use TSQL to parse/substring the data into different fields. It's not a nice job but its doable.

If the data is a mix of fixed width and and delimited you can use a combination of the steps above.

If you have to repeat or automate this process, I recommend you go back to the source of this data and ask them to re-export with a delimiter, grant query access so you can import data directly, or get them to export directly to a database table for you.