SQL Server to MSAccess

[yrf9320]

How can I convert a SQL Server database to an MSAccess database programatically.
thanks

[phunkydude]

I'm not going to go into detail here, just give you some direction.

To create the MDB file you'll need to reference the ADOX library. This library also provides objects with methods to create the tables etc.

You could/may reference the ADODB library and use the recordset object method 'openschema' (with appropriate parameter). This way you may not have things as easy, more coding will be required, but SQL is powerful. You could, for instance, use the execute method of the connection object to CREATE TABLE etc.

Trust this is helpful - atleast a little