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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Have you tried copy|paste special|Values to bring the new data over?
 
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.
 
You must log in or register to reply here.

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Importing data from Excel worksheet into Excel template 2
Importing text with text qualifier 2
How can I migrate MBOX to PST? 2
Importing Text Files Into Access 1
Import more than one .csv file into the same Excel file. 1
Excel 2003 - Importing External Data - formatting problem? 2
Drag text file to Excel -- stopped working 5

Back
Top