Click here to Skip to main content
15,910,411 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: RFID.. Pin
Colin Angus Mackay1-Dec-04 0:20
Colin Angus Mackay1-Dec-04 0:20 
GeneralRe: RFID.. Pin
Dave Kreskowiak1-Dec-04 0:57
mveDave Kreskowiak1-Dec-04 0:57 
Generalplease help me pass. Pin
jettavr66630-Nov-04 7:53
jettavr66630-Nov-04 7:53 
GeneralRe: please help me pass. Pin
Dave Kreskowiak30-Nov-04 9:48
mveDave Kreskowiak30-Nov-04 9:48 
GeneralRe: please help me pass. Pin
R. Thomas30-Nov-04 14:41
R. Thomas30-Nov-04 14:41 
GeneralImport Data into Access Pin
Suresh Prasad30-Nov-04 7:14
Suresh Prasad30-Nov-04 7:14 
GeneralRe: Import Data into Access Pin
Mekong River2-Dec-04 11:00
Mekong River2-Dec-04 11:00 
GeneralRe: Import Data into Access Pin
Suresh Prasad2-Dec-04 13:07
Suresh Prasad2-Dec-04 13:07 
I am trying to import into access data from a progress database. This is how it is setup. The access files is called test1.mdb. The progress database is called springbrook1, and the dsn info is as stated in the code (see below). The table name called customer that I want to import into access. I want to be able to import field1, field2 and field3 from the customer table. This is the code that I have got so far. but now I get the following error message:
The Microsoft Jet databse engine cannot find the input table or query 'mySQL2'. Make sure it exists and that its name is spelled correctly.

My code:
Private Sub ImportToAccess()

Dim Con1 As New ADODB.Connection
Dim Con2 As New ADODB.Connection
Dim mySQL1 As String
Dim mySQL2 As String
Dim myDSN As String
Dim mySET As String

myDSN = "DSN=Springbrook1;UID=suresh;PWD=nissan;"
mySET = "set schema 'pub'"
mySQL2 = "select * from customer"

Con1.Open _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Temp\VB Sample Codes\mcwd\Connect Program\test1.mdb;" & _
"Jet OLEDB:Engine Type=5;"

Con2.Open myDSN
Con2.Execute (mySET)

mySQL1 = "SELECT * INTO [tblCutomer] FROM [mySQL2]"

Con1.Execute mySQL1

Set Con1 = Nothing
Set Con2 = Nothing
Con2.Close
End Sub

GeneralChanging cursor with no forms displayed Pin
Daire Cunningham30-Nov-04 4:25
Daire Cunningham30-Nov-04 4:25 
GeneralRe: Changing cursor with no forms displayed Pin
Dave Kreskowiak30-Nov-04 5:46
mveDave Kreskowiak30-Nov-04 5:46 
GeneralRe: Changing cursor with no forms displayed Pin
Anonymous30-Nov-04 20:59
Anonymous30-Nov-04 20:59 
GeneralRe: Changing cursor with no forms displayed Pin
Daire Cunningham30-Nov-04 23:02
Daire Cunningham30-Nov-04 23:02 
GeneralRe: Changing cursor with no forms displayed Pin
Dave Kreskowiak1-Dec-04 0:54
mveDave Kreskowiak1-Dec-04 0:54 
GeneralRe: Changing cursor with no forms displayed Pin
Anonymous1-Dec-04 13:49
Anonymous1-Dec-04 13:49 
GeneralRe: Changing cursor with no forms displayed Pin
Daire Cunningham2-Dec-04 22:04
Daire Cunningham2-Dec-04 22:04 
Generallogin to server Pin
fo0lish30-Nov-04 3:52
fo0lish30-Nov-04 3:52 
GeneralRe: login to server Pin
Dave Kreskowiak30-Nov-04 5:52
mveDave Kreskowiak30-Nov-04 5:52 
GeneralRe: login to server Pin
fo0lish30-Nov-04 7:47
fo0lish30-Nov-04 7:47 
GeneralRe: login to server Pin
Dave Kreskowiak30-Nov-04 10:02
mveDave Kreskowiak30-Nov-04 10:02 
GeneralDataset Pin
nitin_ion29-Nov-04 22:10
nitin_ion29-Nov-04 22:10 
GeneralRe: Dataset Pin
Jim Matthews30-Nov-04 13:44
Jim Matthews30-Nov-04 13:44 
GeneralForm Design Pin
kellydanielc29-Nov-04 12:39
kellydanielc29-Nov-04 12:39 
GeneralRe: Form Design Pin
Tom John30-Nov-04 5:55
Tom John30-Nov-04 5:55 
GeneralRe: Form Design Pin
The Man from U.N.C.L.E.2-Dec-04 1:29
The Man from U.N.C.L.E.2-Dec-04 1:29 
QuestionHow to handle a propertyvaluechanged event ( or any event) correctly? Pin
David M J29-Nov-04 9:28
David M J29-Nov-04 9:28 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.