Solved

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

Posted on 2003-10-28
6
409 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

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…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

710 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