Solved

Copy Table/data from Sql server to Ms-Access using VB6.

Posted on 2003-10-28
6
390 Views
Last Modified: 2006-11-17
Hi
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.

Regards
Ajay
0
Comment
Question by:ajaykothidar
  • 2
6 Comments
 
LVL 34

Accepted Solution

by:
arbert earned 125 total points
ID: 9639381
Why even use VB6--just create a DTS package in SQL Server that you can schedule to run when needed.

Right click on your SQL Server database and choose export data.  The wizard will walk you through the process and then you can tweak the created package to what you need.

The DTS export to Access will probably be faster than VB...

Brett
0
 
LVL 50

Expert Comment

by:Lowfatspread
ID: 9639421
if this is to be a regular "scheduled" event you could even consider snapshot replication.  
0
 

Author Comment

by:ajaykothidar
ID: 10143573
MOderator,
Pls close this question
0
 
LVL 34

Expert Comment

by:arbert
ID: 10148124
ajaykothidar, you don't just post in the thread and ask that it be closed.  You need to post a "question" in CS with a link to this question and give the reason for closing it....What is the reason??
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

948 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now