How to convert/export SQL Server database to MSAccess from c#

Question

I have a SQL Server database, i need to export all of the data into an Access mdb that users can download. What's the simplest way of doing this from C#?

I realise I could have a blank (but with schema in place) mdb, and when i want to export I could copy it, then read all the data from SQL Server into the mdb via datasets, but that seems like a right faff. Is there an easier way?

Thanks

Why not just use the 'Import/Export' feature in SQL Management Studio to create the Access database when needed? Much easier than writing your own code. — Justin Niessner
– Justin Niessner, Commented Nov 1, 2010 at 16:48
because the user needs to action it, although i may suggest this as an option — Andrew Bullock
– Andrew Bullock, Commented Nov 1, 2010 at 16:57
is there a way to automate/expose that feature somehow so it doesnt need to be a manual task? — Andrew Bullock
– Andrew Bullock, Commented Nov 1, 2010 at 17:00
It is possible to create an mdb or accdb with ADOX, if that is any help: support.microsoft.com/kb/317881 — Fionnuala
– Fionnuala, Commented Nov 1, 2010 at 22:33

John Warlow · Accepted Answer · 2010-11-01 17:01:07Z

2

Could you create a DTS Package to do the export, then write a C# app to execute the DTS package, the user then just needs to execute your C# app? You could also set the DTS package to run automatically if you don't want user interaction.

answered Nov 1, 2010 at 17:01

John Warlow

3,0121 gold badge36 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to convert/export SQL Server database to MSAccess from c#

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related