View Single Post
  #2  
Old June 4th, 2010, 01:39 PM posted to microsoft.public.excel.worksheet.functions
Luke M[_4_]
external usenet poster
 
Posts: 451
Default Import old dos sequencial data

Text to Columns, fixed length?

--
Best Regards,

Luke M
"Rich Stone" wrote in message
...
I have an old database that stored it's data in a sequencial format with
fixed lengths for each field. As Windows 7 64-bit no longer allows the
running of the database I need to access the data in another way so wish
to
import it to excel. I can get as far as marking the first record's field
lengths but there does not seem to be a way of marking the end of the
record.
Instead it leaves the rest of the data in the final field!

Can anyone suggest the best way of doing this? Thank you.