Recent content by ronstar

connecting to API on server Hi, I would like to expand my program so that it can connect to an API of a tool on an external server. The connection to the API is done with Server IP, UID, PW. I was wondering if anyone could direct me on my way to establishing such a connection and make calls...

Hi I cant see the difference between the line you posted and the one i did because they are editing the string. what I ported was username(colon)pw@server.com/port:1222 not sure about hte scripting. I cant find anything in the documentation...

Hi Everyone My objective is to download, a file from an sftp server, and I am trying to adapt the code from another question on this site to do so (I pasted the code below for your convinience). I downloaded psftp from putty. psftp closes when I try to connect manually using the following...

Apparently the server is an SFTP server, so I need different code. I have been looking but it seems that one always has to buy code/packages. Can anyone please provide sample code. thank you

Hi all, Below is the code I am using to download a file from an FTP server. When "Set FTP = New Inet" is executed I get error: runtime error 429 ActiveX component can't create object (p.s. I checked hte Microsoft Internet Transfer Control 6.0 (SP6) in the references, after installing msinet...

Hi Sparks, I am trying your suggestion, but am running into difficulties downloading the file via ftp.I am reusing code I found in the site you directed me to. Basically, I am trying to download the entire activity.log file to my local pc as you suggested and write it to a file called...

Hi That was the first thing I explained at the top of the posting. Here is a summary for your convienience. hopefully it is clearer: 1. I have a .log file that is located on a server and to which data is written be the server continuasly (i wrote at the beginign that it is a .csv by mistake)...

Hi Some of the data is being lost when it is pulled into the linked table from the .log file, because it is being identified as a number, but farther down the line records appear where the data is a string. since the field data type is being set by the first 25 records, the data from the...

|Hi, What is the purpose of the & " Since I dont understand, I am finding it problematic to impement this suggestiion. The string is already in quotes, and adding & " like that is causing an error Is this what I am supposed to do? " Select ..... , MTActivityTemp.name, " & "...

When I add & "" in the string, I get an error. Never seen that before. I must be missing something. thanks

Hi VBAInet, sorry dont follow. :( this is the insert statement that pulls the data from the linked table into the permanent table (which I then use). I shortened it so that it is easier to follow. the field that is I need as string and is always a number in the linked table is "deal_ref"...

Hi, Setting TypeGuessRows = 0 diorectly in the regedit did not help. is this s different solution? if so, I do not understand where to set IMEX extended property to 0. do I have to link the table programatically with VBA? right now it is connected using hte wazard thanks

hi again, they already are formated as text in excel, but that doesnt seem to matter. I did not chose that formating though. The excel file is linked to a .log file and is pulling the data from it. the reason I am using excel as an intermediary between the .log and access are: 1. access...

Hi there Sparks80 I set TypeGuessRows = 0 as you suggested. Unfortunately the program gets stuck when the value is 0. maybe there are just too many rows and it cant decide at all. I tried TypeGuessRows = 100 as I can see that within 100 rows there is the entire variety of data (not a good...

Hello all, I am linking an access table to an excel spread sheet. The spread sheet in turns is linked via FTP to a csv file that is on a remote drive and that is continually being updated in real time. The spread sheet data is being refreshed every 10 minutes with new CSV data. One of the...