Importing a Text File

[patm]

I have a standard TAB delimited text file that I need to
import into a worksheet. This file is generated by
another application and I simply want to load the data
into Excel so our users can manipulate it themselves,
however they want to look at it.

When I just do a Data->Import External Data into a totally
blank worksheet, everything works fine.

However, when I try to do a Data->Import External Data
into the second row of a new worksheet (the first row
contains a list of column headings) created from a
template I created (the template simply puts some data
validation on a few columns and has a macro that can be
used to automatically save the worksheet to a specifically
named file), the data is imported correctly into the
second and subsequent rows, but the first row (with the
headings) is shifted over two columns to the right (thus
messing up the data validation on the columns).

Does anyone have any ideas about what I am doing wrong?

Any help would be appreciated.

Thanks.

Pat M.

 

[terry]

The behavior you describe could be caused by an
incompatibility between your template worksheet and the
file you're importing.

Be sure that the file you are importing has the same
number of columns per row and that the columns in the file
correspond to the columns in your worksheet.

Hope this helps.

 

[terry]

The behavior you describe could be caused by an
incompatibility between your template worksheet and the
file you're importing.

Be sure that the file you are importing has the same
number of columns per row and that the columns in the file
correspond to the columns in your worksheet.

Hope this helps.