PC Review


Reply
Thread Tools Rate Thread

Importing Data without 'help'

 
 
Brian Dellinger @ Dartmouth College
Guest
Posts: n/a
 
      13th Feb 2004
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!
 
Reply With Quote
 
 
 
 
Jim Rech
Guest
Posts: n/a
 
      13th Feb 2004
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


 
Reply With Quote
 
 
 
 
Guest
Posts: n/a
 
      13th Feb 2004
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
>
>
>.
>

 
Reply With Quote
 
=?Utf-8?B?dGp0amp0anQ=?=
Guest
Posts: n/a
 
      14th Feb 2004
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can you use VBA to query an Access database without importing data =?Utf-8?B?Sm9uUg==?= Microsoft Excel Programming 10 4th Sep 2007 02:00 AM
importing an excel worksheet without the data that is currently hi =?Utf-8?B?S2VsbHk=?= Microsoft Access External Data 1 27th Dec 2005 06:59 PM
Access Data without Importing or Linking =?Utf-8?B?QnJhZA==?= Microsoft Access External Data 21 4th Oct 2005 10:27 PM
Importing Data Into Existing Tables Without Emptying Them First =?Utf-8?B?QW15IEUuIEJhZ2dvdHQ=?= Microsoft Access External Data 8 27th Sep 2005 10:22 PM
Importing data without losing calulations or formate garrwan Microsoft Excel Misc 1 15th Jan 2004 07:47 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:42 AM.