External table is not in the expected format

G

getsum

I get this error while trying to run a DTS package built to import an
excel file.
After some reading I'm thinking that the excel file could be in the
wrong format, but I'm not sure???

The process is this: A user logs on to a webpage, runs a report that
gets displayed in a gridview - then they export it to Excel. They make
changes to the Excel document and then upload it and execute a dts to
perform an update so to speak. Everything works fine except the DTS
package. I was thinking that since we are exporting a gridview to an
excel file, that it might not be a compatible file. Anyone have any
ideas or experience with this? Thanks in advance.

Robert
 
Top