p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Visual Studio 2005 (http://p2p.wrox.com/forumdisplay.php?f=140)
-   -   error: "Not a legal OleAut"when importing Excel2007 into SQL (http://p2p.wrox.com/showthread.php?t=93610)

dongtrien September 24th, 2014 05:39 AM

error: "Not a legal OleAut"when importing Excel2007 into SQL
 
I am be an error importing the Excel2007: "Not a legal OleAut date", you see my code below:


Code:

public static void ImportToSql(string excelfilepath)
        {
            string ssqltable = "TABHD";
            string myexceldataquery = "SELECT * FROM [dbo_TABHD]";
            try
            {
                string sexcelconnectionstring = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source =" + excelfilepath + "; Extended Properties=\"Excel 12.0; HDR=Yes; IMEX=2\"";
                string ssqlconnectionstring = @"server = itfriend;Database=HD;integrated security = true";
                //execute a query to erase any previous data from our destination table
                string sclearsql = "delete " + ssqltable;
                INSERTING IT.INSTEAD I WANT TO UPDATE TABLE DATA"
                SqlConnection sqlconn = new SqlConnection(ssqlconnectionstring);               
                OleDbConnection oledbconn = new OleDbConnection(sexcelconnectionstring);
                OleDbCommand oledbcmd = new OleDbCommand(myexceldataquery, oledbconn);
                oledbconn.Open();
                OleDbDataReader dr = oledbcmd.ExecuteReader();
                SqlBulkCopy bulkcopy = new SqlBulkCopy(ssqlconnectionstring);
                bulkcopy.DestinationTableName = ssqltable;
                bulkcopy.WriteToServer(dr); // Eror in here: "Not a legal OleAut date"
                Console.WriteLine(".xlsx file imported succssessfully into database.", bulkcopy.NotifyAfter);
                oledbconn.Close();
            }
            catch (Exception ex)
            {
                //handle exception
                MessageBox.Show(ex.Message.ToString(), "Warning !");
            }
        }



All times are GMT -4. The time now is 06:01 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.