what's your file like, If there is a common delimitter(such as commas)? then you can import as text delimitted
or you can use fixed width if there is equal spacing
you should just be able to open the file and run through the wizard
or you could copy and paste the text into the workbook and work with it from there
if your still having problems post back
Actually what we want to do is, we have one report which will print out in text format, and we have one option for user to export it to Excel format.
we can not add delimiters in text file becoz the text file will be print out by customer as report also.
Currently we fixed the field length for detail part, but when user request to print header and footer as well, the alignment will be out. The header and footer info will be chop off to the length we set for detail.
Im afraid i don't know to much about delphi, I could do this in VB or VBA, depends on how you want to do this, i could show you a routine for getting your file accross with VBA and what you could set delphi to do is to open the macro book instead of the transported text,