Message
From
17/03/2010 22:06:52
To
Todo
General information
Fórum:
ASP.NET
Category:
Coding, syntax and commands
Título:
Problem Loading Excel File To DS
Miscellaneous
ID da thread:
01455268
ID da mensagem:
01455268
Views:
96
I posted this 2 days ago and got no response.
I'm importing an Excel file into a DS:
The Quanties export to CSV, so if I had to I could force the file to a CVS, the parse the CVS, but that's alot of work.
Anyone have any thoughts on why this is happening?
I'm importing an Excel file into a DS:
da.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FileName + ";" + "Extended Properties=Excel 8.0;"; DataSet ds = da.ExecuteQuery("select * from [New Quote$]", CommandType.Text);When I look at the DS in the DS Browser, the Quantity columns are empty. The data is there in the Excel file.
The Quanties export to CSV, so if I had to I could force the file to a CVS, the parse the CVS, but that's alot of work.
Anyone have any thoughts on why this is happening?
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people