yrf9320
May 29th, 2001, 03:08 PM
How can I convert a SQL Server database to an MSAccess database programatically.
thanks
thanks
Click to See Complete Forum and Search --> : SQL Server to MSAccess
phunkydude
May 29th, 2001, 04:25 PM
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 ;)
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 ;)
codeguru.com
Copyright Internet.com Inc., All Rights Reserved.
Copyright Internet.com Inc., All Rights Reserved.