Alan

Try below

1. Rename the file to txt
2. FileOpen*.txt
3. From Text Import Wizard Step 1 ..hit Next
4. Select comma as the delimiter in Step 2
5. In Step 3 , from Data Preview area..select the column you want to be
displayed as text. If you want all columns to be selected with Shift key
pressed select all fields.. The background of selected fields wil be black.

Hit OK

Try this and proceed with recording a macro....if this is not for a one time
business.

If this post helps click Yes
---------------
Jacob Skaria


"Alan" wrote:

On Jun 2, 12:06 pm, Gary''s Student
wrote:
Your macro must do exactly what a human would do faced with the same situation.

HUMAN:

Data Import External Data Import data...

The human would then tell the Import Wizard the filespec and the format of
the various fields. Thus 12/25/2009 can be imported as Text rather than Date.


BUT I tried this. It did not work. Neither General nor Text import
worked. See original post.

Thanks, Alan