Import a Table into Access

[gregarican]

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?

[gregarican]

On Jun 19, 10:17 am, gregarican <[e-mail]:

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?

Rather than work outside Access using C# I just resorted to using VBA
within Access itself. Using the DoCmd.TransferDatabase method I was
able to bring in the SQL tables and then just called the Module
procedure from an Access Macro. Done deal :-)

[Nicholas Paldino [.NET/C# MVP]]

You could also look into using Data Transformation Services if your app
allows it.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"gregarican" <gr*********@gmail.comwrote in message
news:11**********************@g4g2000hsf.googlegro ups.com...

On Jun 19, 10:17 am, gregarican <[e-mail]:

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

Rather than work outside Access using C# I just resorted to using VBA
within Access itself. Using the DoCmd.TransferDatabase method I was
able to bring in the SQL tables and then just called the Module
procedure from an Access Macro. Done deal :-)