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
__Stephen
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
__Stephen