Click here to Skip to main content
15,906,766 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
actually ...first of all i export Excel sheet then same sheet i am trying to import in same Sql table...in asp.net.

so it give an error--"External table is not in Expected format".
in my system i installed MS Office 2007.
when i open Exported Excel file then it give a Confirm Pop Up message that "Format is not supported" when i click ok then it opened in same format. but could not again import data into same Table.so please give me solution how to import this file.

i also make manually a MS excel sheet for exporting then it worked but not Working in exported sheet....
Posted
Updated 25-Jul-12 1:52am
v2
Comments
Prasad_Kulkarni 25-Jul-12 5:33am    
You've already ask'd this question:
Export and Import Excel to Sql Database[^]
Don't re-post your questions, If you want to modify or update your question then use 'Improve question' widget. But don't re-post it.

1 solution

 
Share this answer
 
Comments
mayank1290 26-Jul-12 1:50am    
when i am trying to import excel to sql database i found error-Could not find installable ISAM.i installed office 2003
my connection string is-
string excelConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=H:\a.xls;Extended Properties=""Excel 8.0 Xml;HDR=Yes""";

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900