Search results

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...

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...

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...

Hi Everyone, I have .csv files which I need ot import into Access, but when imported directly some data is lost (even when I do the import manually). When I first import the data from .csv to excel (2003), and only then to Access the data is not lost. I have the part of importing from excel...

Hi Everyone, I have a challenging problem (at least for me it is) I have a table with about 200 columns, which are not logically named. there are 1.6 million records in the table. No column alone can form a PK as all of them have duplicate data. I do not know how many columns I need to...