Import a Table into Access

  • Thread starter Thread starter gregarican
  • Start date Start date
G

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?
 
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?
Click to expand...

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 :-)
 
You could also look into using Data Transformation Services if your app
allows it.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert or Save file into SQL Server Database Table with C# Examplesand VB.Net Examples 2
Import files into access 1
How to export table from outlook into ms access table? 0
Importing Text Files Into Access 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Access 2010 append query to SQL is very slow 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
easiest way to upload a C# class library to a SQL server 2005 and deploy as CLR function 2

Back
Top