bghodsi

Hi Folks: The following is the complete coding for an application which I wrote to move data from sql 2000 to MS Access 2003. The coding looks fine to me but I am still getting an error. Could someone tell me what I am doing wrong. Thanks in advance Bob …

Hi folks: Can anyone tell me what I am doing wrong in the coding below: [code] Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Try Dim ConnectionString As String = "Server=hp;database=library;integrated security=SSPI" MessageBox.Show("Connection established") Dim sql As String = "SELECT snippetID, snippetName, snippetSource, snippetCode FROM snippet …

The following is the complete coding for moving data from sql to access, I get an error saying that Microsoft JET Database Engine missing (;) at the end of sql statement!!!! Could you tell me what I am doing wrong? Imports System.Data.OleDb Imports System.Data.SqlClient Public Class frmMain Inherits System.Windows.Forms.Form Private …

I am splitting the label file path into an array as shown below. When I run the program, I get the error indicated at bottom of this page, Can anyone tell me how to avoid making this error. Thanks Dim arrFilename() As String = Split(lblFilePath.Text, "\") arrFilename.Reverse(arrFilename) Error 1 Access …

Hi Folks: I am still having trouble moving data between sql and ms access databases. Has anyone got any idea? Bob Ghodsi

Hi folks: I get the following error when I try to convert sql to access: Microsoft JET Database Engine missing (;) at end of sql statement. The first part works fine but I get the error running second part. Below is the complete coding in vb.net for data transfer. [code] …