I have an Excel with data, I want to export this data to my SQL data table, i tried to this using the query like -
SELECT * INTO XLImport3 FROM OPENDATASOURCE('Microsoft.
Extended Properties=Excel 8.0')...[Customers$]
I got this from - http://support.microsoft.com/kb/321686
but the problem is it took the datatypes as it can, but I already have a designed table with particular datatypes I want the data to be Exported as I designed the datatable without changing the datatypes of the table. In-fact, it created a new data table but I want the data to exported to the data table that i designed.
How can i do this? Please help me.
Thanks in advance.