I am receiving an error when I pass data from one workbook into another workbook. The error only happens if I do not manually open the Data_Extract.xlsx file and save it. This file is opened and saved by .Net in the first step of the code. Then I have another process that calls the new data file name and opens it up to pull the data.
I have added code to open the Data_Extract file and save it again in the code before I open it and pull the data into it, but I still get the error "External Talbe is not in the expected format."
When this line of code is processed. ---- oleDbDataAdapter1.Fill(ExcelDS);
Again, this error does not come up if I
open the file and save it manually.Error when passing
This message was posted using Email2Forum by GeorgeClark.