Solved

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

Posted on 2003-10-28
6
419 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

617 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