There's a data integration application I have to support that uploads
data using Access (oy vey). All of my proprietary data is housed in
intermediate SQL Server tables. Currently I perform the uploads by
opening up Access, then importing the SQL Server tables using Access
so they reside there in the MDB file. Clunky at best since this data
upload will be automatically run each day.
What would be a programmatic way using C# that I could whip up a
script that would do the job? I have googled around a bit and couldn't
find a similar example and am relatively new to C#. Anyone have a good
suggestion or two?