Urgent Import Problem no row deliminator

[steven H]

I have a txt file to import, the fields are in fixed width format. I have tried to import it to access with no success. I have attempted to import using sql server 2000 import export utility but I am getting a message telling me there are no row deliminators. I need to insert a row deliminator after every 400 characters - however the table will not open in access. Any ideas?

 

[steven H]

it was originally in fixed length fields (just had a try on text to columns - not enough memory msg box)

 

[Norie]

What about using the string functions MID, LEFT, RIGHT etc?

 

[steven H]

I have started to try this got a feeling it might be laborious though gonna have a go though..

 

[Norie]

It probably will be laborious.

After doing the first few you should check to see if there is any way it can be automated.