>I was wondering what other have done with pulling data out of excel files for input into their own backend data.
>
>I have a sheet that has two cross tabs on the top of it which quantify & total the abuse or back slap that this B2B customer is providing. I need to read down the 6 +/- columns of data and identify if I need to load that row into my data.
>
>So this isn't a DTS job because they resend the same sheet every day of the month with the newer details on the top of the sheet. Of course some items could change from week to week that I have to check, but I can do this on the table level.
>
>This will be a WIN Form and it's not determined if it's going to be in 2003 or 2005 yet. So if there is a better reason to use 2005 PLEASE let me know :)
>
>I have tried the save as XML within excel, but it fails.
>
>Any ideas?
>
>TIA
I am using ADO for this. Like (VB.NEt, VB, FOxPro):
cnnExcel = CreateObject("ADODB.Connection")
cnnExcel.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + _
Excelfile + ";Extended Properties='Excel 8.0;HDR=YES;IMEX=1'")
.....