View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Peruanos72 Peruanos72 is offline
external usenet poster
 
Posts: 58
Default Import file to excel

The file type is unknown. It's created by a program called Health Axis. Using
notepad on three pc's the data looks the same except for one of the pc's (A
pc I don't use). The spacing is a different. It's the same on the pc I
normally use (imports correctly) and on the another pc it's also the same but
does not import correctly. I did notice that even thought both pc's have
excel 2003 the versions are different. I'm going to see if that has an impact
on how the file is imported.

Thanks!!!

"Joel" wrote:

there could be a number of reasons.

1) Is the file a CSV. If so open the file using Notepad a look at the data
on the 2 PC's. Post the data so we can see what it looks like

2) Maybe there were rows hiddin on one of the PC's before theh data was
imported

3) Maybe there was an autofilter set on the worksheet before the data was
imported.

4) Was a macro used to import the data. Post the macro.

"Peruanos72" wrote:

I have a report that's imported into excel and the data begins on row 4.
There's
data in rows 4-7. Rows 8-11 are blank and the remaining rows contain data.
Here's my problem...When I import using the pc the excel file was created on
the data is imported as stated above. When i import using another pc, rows
8-11 that were blank now contain the data that should be in rows 12, 13, 14,
15, etc...
it's like rows 8-11 were deleted and the data was shifted up.

Anyone know why the report would import differently using another pc?