/// <summary>
/// Import a text file into an existing Excel file, creates a new WorkSheet and
/// populates the WorkSheet with comma delimited data from the text file. Note that
/// the folder in this case is our database so in the method ImportFromTextFile the
/// connection string has DATABASE which is set the current application's executable
/// folder.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cmdImportTextFileIntoWorkSheetOleDb_Click(object sender, EventArgs e)
{
var oleOperations = new OledbCode.Operations();
var excelFileName = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "ImportFromTextFile.xlsx");
var textFileName = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Sample1.txt");
var sheetName = "Customers";
if (oleOperations.ImportFromTextFile(excelFileName, textFileName, sheetName))
{
MessageBox.Show("Import done");
}
else
{
Dialogs.ExceptionDialog(oleOperations.LastException);
}
}
