Sql 2000 into Access db 2000 using vb.net

20 New Member

Hello,

I am trying to right an application that will dump the information from an sql server 2000 into Access 2000 via VB.net

The gist is, we have 1 table in sql 2000, it has 5 columns and 15 rows of data, one of the columns is a date that holds the info of when the record was added.

I want to select all rows that have a date between X and X and then dump them, in there entirety into an Access DB that I can then give to the client for them to build their own reporting off of.

I need to use VB.net 2005 to do this as the application will be placed into a schedule to run once every week or so.

Any ideas on how to do a direct dump with out reading every field of every line into a string to compile an insert statement to run into access.

The other problem is that one of the sql fields is a memo field and is multi line.

Please let me know what you think.

Oct 19 '07 #1

Subscribe Reply

992

Javilen

New Member

I solved it on my own, I removed the vb.net programming and used the DTS built into sql to export the table I wanted based on the fields I wanted to the access DB. The DTS has a scheduling option that allowed me to schedule the process to run 1 a week when I wanted.

Thanks

Oct 19 '07 #2

Plater

7,872

Recognized Expert Expert

I was going to suggest using DTS, but I wasn't sure how well DTS worked with automatic schedualing

Oct 19 '07 #3

Similar topics

2133

Cannot See a Newly Installed SQL Server 2000 (No Active Directory)

by: Jay Chan | last post by:

We have just installed a SQL Server 2000 (SP 3A) onto a computer that has Windows-2003 Server on it. Now, we cannot get access to that database server from other computers. Seem like this may be an issue with Active Directory. Our network consists of Windows-2000 Servers (SP 4) and Windows-2000 workstations and Windows-XP workstations. We also have SQL Server 2000 (SP2) in three Windows-2000 servers. All work fine. Recently, we get a...

Microsoft SQL Server

5733

Cannot See a Newly Installed SQL Server 2000 (No Active Directory)

by: Jay Chan | last post by:

Microsoft SQL Server

2426

Access 2000 Distributing

by: Scott | last post by:

Any help would be grateful :-) Problem: When I test my installation of Access 2000 MDE, I get the following error: "Unrecognised Format".. This means that Access 97 cannot read Access 2000. But I was under the Impression that Access 2000, could be redistributed using Install Shield 7 and that it would not effect the workstations current status. My Current senario is:

Microsoft Access / VBA

2152

Access 2000 Stability

by: Serious_Practitioner | last post by:

....or lack thereof... I use Access 2000 which I own as part of Office 2000 Professional. I've had enough trouble with glitches to ask if these are common occurrences - 1. Sometimes the "Help" system won't start. Sometimes it will. It starts more often than not. I don't see any pattern to when it does or doesn't. If the Access "help" won't start, the Visual Basic "Help" usually won't start either. This glitch has been going on for...

Microsoft Access / VBA

4514

Advice needed: Should we upgrade MS Access 2000? And if so to what?

by: ship | last post by:

Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003? (particularly Access 2003). We are just a small company and this is a big decision for us(!) It's not just the money it's committing to an new version of Access!

Microsoft Access / VBA

8395

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8310

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8826

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8732

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

5632

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4155

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

2726

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1955

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1615

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General