Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Posts
    57

    Unanswered: Export from text file to Excel

    Hi,

    have any idea to export text file info to excel?

  2. #2
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    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

  3. #3
    Join Date
    Jun 2004
    Posts
    57
    Hi,

    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.

    FYI, we are using Delphi.

  4. #4
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    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,

    Dave

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •