file transer method??

[techqueen]

I currently program dialogs to automate all of my tasks and data entry in our old system. But I would like to download the data into Access tables (for example) to manipulate the data then upload back to the mainframe. Having trouble trying to figure out how to download imbedded data from the host. Tried using the file transfer wizard but can't seem to figure it out? any suggestions?

 

[gehrman]

Here is some code to connect to access in a macro. Works like a champ!
Dim adoConn as object
Dim adoRS as object
Dim strConString as string
Dim strSQL as string
Dim ID as string
dim time_stamp as string
time_Stamp = format (now,"short time&quot

strConString ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\sbcaitin.user.ameritech.com\c$\my documents\access\data.mdb;"
Set adoConn = createobject("ADODB.CONNECTION&quot
set adoRS = createobject ("ADODB.Recordset&quot
adoConn.open strConString
strSQL = "Select * from tblInfo WHERE State = 'IL'"
adoRS.open strSQL, adoconn

'access connected - now scroll thru recordset

do until adors.eof
'blah blah blah
loop

 

[techqueen]

That will be very helpful. I have recently transfered all of my code into VB for my users to view and manipulate the host info in an existing database. It will be great to be able to access the data from there as well. Thanks..

 

[dwolters]

Yes, the file transfer wizard is very confusing.
We use it here all the time, but until you figure out the
first one, it's all greek.
Anyway, if you're still interested in using the wizard,
e-mail me back and we can step you thru this.