Importing Data without 'help'

Discussion in 'Microsoft Excel New Users' started by Brian Dellinger @ Dartmouth College, Feb 13, 2004.

  1. Hi all.

    My office downloads a dataset (tab delimited) that we
    process for insertion into a database (Oracle).

    The vendor who provides us the data hasn't done a great
    job of data scrubbing, so we need to go in and make some
    changes to the file in order to input it cleanly. Excel
    makes it easy to do this by allowing us to select specfic
    columns and replace illegal characters, etc.

    The trick is that Excel also *automatically* reformats
    several columns for us (dropping leading zeros from
    dates, zip codes, etc) ... This means we have to touch
    even *more* fields.

    Is there a way to instruct excel to open a particular
    file 'as it is' and not apply any other formatting?

    Thanks in advance for your help!
     
    Brian Dellinger @ Dartmouth College, Feb 13, 2004
    #1
    1. Advertisements

  2. Brian Dellinger @ Dartmouth College

    Jim Rech Guest

    If the data file has an extension other than CSV Excel will open the Text
    Import Wizard when you open the file. The third screen of the wizard lets
    to set the format of each field. Pick Text for the fields that you do not
    want reformatted.

    --
    Jim Rech
    Excel MVP
     
    Jim Rech, Feb 13, 2004
    #2
    1. Advertisements

  3. Brian Dellinger @ Dartmouth College

    Guest Guest

    Jim,

    Oddly enough, the file is a .txt file (tab delimited) and
    excel doesn't bring up the wizard.

    That said, I can certainly rename the file to .fup or
    something equally bizarre and invoke the wizard.

    You ROCK!
    >-----Original Message-----
    >If the data file has an extension other than CSV Excel

    will open the Text
    >Import Wizard when you open the file. The third screen

    of the wizard lets
    >to set the format of each field. Pick Text for the

    fields that you do not
    >want reformatted.
    >
    >--
    >Jim Rech
    >Excel MVP
    >
    >
    >.
    >
     
    Guest, Feb 13, 2004
    #3
  4. Brian Dellinger @ Dartmouth College

    Guest Guest

    You might be able to force the Wizard to open by doing this
    Open a blank workbook and go to Data|Import External Data
    This works for me

    tj
     
    Guest, Feb 14, 2004
    #4
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    Importing Word MERGEFORMAT field data

    Guest, Feb 16, 2004, in forum: Microsoft Excel New Users
    Replies:
    0
    Views:
    1,229
    Guest
    Feb 16, 2004
  2. DUNDAPANJ

    Importing Access Data

    DUNDAPANJ, May 5, 2004, in forum: Microsoft Excel New Users
    Replies:
    0
    Views:
    214
    DUNDAPANJ
    May 5, 2004
  3. Linda Wakefield

    Importing data

    Linda Wakefield, Jun 2, 2004, in forum: Microsoft Excel New Users
    Replies:
    1
    Views:
    200
  4. flashing frank

    positive value and importing data

    flashing frank, Aug 28, 2004, in forum: Microsoft Excel New Users
    Replies:
    3
    Views:
    185
    Dave Peterson
    Aug 28, 2004
  5. Guest
    Replies:
    2
    Views:
    411
    David Biddulph
    Oct 18, 2007
Loading...

Share This Page