Copy Table/data from Sql server to Ms-Access using VB6.
Posted on 2003-10-28
I am trying to take the backup of the data of our application which has database on
SQL Server 2000.I need to take the backup on MS-Access database.
All this has to be a run time process.
I have a list of specific static data tables which need to be first created in MS-Access
and then the data needs to be copied.
Currently i am using DAO to create Access database,tables and fields one by one which is very tedious.
Is there any method/function using VB6 to copy the schema of tables in SQL 2000 to MS-Access.