Loading Excel File

I've created a couple packages used to extract information from a database, load it into an excel file (97-2003) and then send the file off.  A user will make changes, add and remove records then send it back.  The file will be reloaded, and set up the new year's information.

The problem I'm having is when adding a record is to the bottom of the file the import process does not recognize that record there.  Even a dataviewer in the data flow doesn't see the record! If the record is added somewhere in the middle of the file, it recognizes it.

The process that is loading the file copies a template excel file.  I've tried adding a bunch of empty rows to the template, well beyond the number of rows being extracted.

Has anyone had this type of problem, or have a suggestion?

Any help would be much appreciated!

- Rob

I would double check and make sure the data that is being added by users is the same data type.  I've seen mixed data types in excel when rows are added after the fact.

Thanks for the response Devin!

Thought that was it too and found some articles about the data types and connection string changes.  So far, I've been the only one adding the records and have kept the same data types.  I've even tried pasting a row that was previously loaded at the end of the file, with no luck!  VERY frustrating!

If you have any other ideas I'd sure appreceiate it.

- Rob