+ Reply to Thread
Results 1 to 3 of 3

Excel Text Import Wizard

  1. #1
    ozburger@gmail.com
    Guest

    Excel Text Import Wizard

    Does anybody know of a way to automatically fire the Text Import Wizard
    in excel. What I am trying to do is create an asp page for my users
    which contains links to reports. These reports are text files which
    need to be imported into excel. By clicking on the link my users will
    open the file in excel and be prompted with the Text Import Wizard to
    format the columns. As we run many thousands of different reports I
    think that it would be impossible to predefine the columns, so this
    must be done by the end user when they open it.
    I have tried naming the text file as .csv and .xls, but they just open
    with everything in the first column.


  2. #2
    Gary''s Student
    Guest

    RE: Excel Text Import Wizard

    Try naming them .txt
    --
    Gary''s Student


    "ozburger@gmail.com" wrote:

    > Does anybody know of a way to automatically fire the Text Import Wizard
    > in excel. What I am trying to do is create an asp page for my users
    > which contains links to reports. These reports are text files which
    > need to be imported into excel. By clicking on the link my users will
    > open the file in excel and be prompted with the Text Import Wizard to
    > format the columns. As we run many thousands of different reports I
    > think that it would be impossible to predefine the columns, so this
    > must be done by the end user when they open it.
    > I have tried naming the text file as .csv and .xls, but they just open
    > with everything in the first column.
    >
    >


  3. #3
    ozburger@gmail.com
    Guest

    Re: Excel Text Import Wizard

    This produces the same as .xls or .csv.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1