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?

 

[Norie]

I have tried to import it to access with no success

What was the problem?

 

[steven H]

the application crashed on import having frozen for 30m min, i attempted to use sql server 2000 import export wizard to import and as i detailed in my earlier post, there are no row return characters

 

[Norie]

Try importing into Excel.

 

[steven H]

Well over 65k records but will go for a partial input

 

[bat17]

When it froze in Access did you try a Ctrl-Break to stop it running? a lot of import errors will slow it right down.

Peter

 

[steven H]

Guys

Its gone in and in under 65k, seems to have found a character to use as a row deliminator.. Peter I did control break however it continued to be frozen ended up control alt deleted out of the process. I will check out now how the data has been carried into excel ie cells filled and characters per cell.

Will post back when I can add something more

Steven

 

[Norie]

Is there any delimeter in the data?

Is it just long lines of text?

 

[steven H]

Norie

The cells with data in are A1 to A3089 each of these cells has 3137 characters in (using the Len function) - no there are no deliminators in the cells.

Steven

 

[Norie]

How is the data organised?

Try looking at Data>Text to Columns.