John Baird
Coatesville, Pennsylvanie, États-Unis
Versions des environnements
Network:
Windows 2000 Server
My data import tool simply automates excel, pulling the entire worksheet into a dataset. I can then do what I want with it and write the results to sql server. If you google on automate excel and c# you can find a number of examples.
>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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement