Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.79K
~1K People Reached
Favorite Forums
Web Development x 1
Favorite Tags
microsoft:access x 1
.net:c# x 1
1 Posted Topic
Try this: [CODE] if (strFileType.Trim() == ".xls") { strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + [B]postedFile.FileName [/B]+ ";Extended Properties=Excel 8.0;"; //strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + postedFile + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\""; } else if (strFileType.Trim() == ".xlsx") { strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + [B]postedFile.FileName [/B]+ ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\""; }[/CODE]
The End.