Last post Jun 19, 2012 09:42 PM by Decker Dong - MSFT
Jun 18, 2012 05:36 PM|acheo|LINK
I'm trying to import one single table from Excell to SQL Server. There is no constraint or anything.
When I open the table in SQL Server some columns fail to show the real data. In Excell, everything was formatted text so I figured it would be pretty simple to map.
Any idea what cause this problem?
ps I used the 32 converter. I run on WIndows 7.
Jun 19, 2012 09:42 PM|Decker Dong - MSFT|LINK
Have you following the wizard to export the Excel into the SQL DataTable？Maybe you can write a SQL statement and do execute in the VS to export the specific table from Excel to SQL by using this：