How do I set up a text file import template in Excel 2003?

E

Excel User

I have tried creating a template spreadsheet but when I bring in new data the
formats and data types are not maintained for the imported data. The
imported text file is close to 400 columns (separated into about 50 fields)
and various rows.
 
D

Dave Peterson

My suggestion of copy|paste special|values was after the data was imported.

But when I have the same fileformat that I have to import into excel, I'll
record a macro when I do it once manually.

Then I just run that macro when I need to do it again.

In fact, I include most of the formatting stuff in the macro.

Then I can copy and paste to any location that I want.
 
Top