By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,666 Members | 1,909 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,666 IT Pros & Developers. It's quick & easy.

Sucking data out of Excel Sheet from B2B

P: n/a
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?


Nov 7 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.