Search results

Hi, I have a text file (attached), which contains data in the below format, which I need to import into Access table. I have a parsing sql as below (select top 1 value from #temp where field_id='20c') as 'Message_Reference', (select top 1 value from #temp where field_id='98c') as...

Hi, My text file looks as below A1010307300000038824 2024178000010000038800000380 O 0000038824-000001S513000000388 06055JFD6OM 000000000 * 85173 01965137 SB 030000000 533SEG5 Private Sub Command0_Click() Dim FSO As Object, objFolder As Object, objFile As Object Set FSO =...

Yes. Able to use winscp

yes

I did those steps (ip, user, password) and got to the step which I listed above and it stalls

I did go the cmd prompt way. I was able to ftp and get to "/" is current directory ftp> ls It got as far as "200 PORT command successful. 150 Opening ASCII mode data connection. It stalls after this. Probably, the OS is stopping this.

I need to read these contents into a single field in my Access table after which I parse using Mid function. I need to rename them as .txt files either in the same folder or different. I will be using either the transfertext or VBA code to get the data into Access. I wonder if the text files can...

Yes, I mean change the extension to .txt

I need to read these contents into a single field in my Access table after which I parse using Mid function. I will be using either the transfertext or VBA code to get the data into Access. Under current FTPRCV or RR, I am unable to or I am unaware how to. I think replacing the file extension...

Our IT department for some strange reason have winscp exe and no ftp exe

Hi, I receive data in files with FTPRCV types dumped into my folder I need to loop through the folder and save these files as txt files I receive files as RR20240628060101, RR20240628060102..... Also, if file types are 20240628060101.FTPRCV, 20240628060102.FTPRCV........then how would the code...

Since I do not have ftp and I use winscp, can I use the command as ExecCommand "C:\software\winscp.exe -ns:c\Daily\inputs\ftpdaily.bat", 1 also. how can I call this from a command button?

What is ftpfocusmode & tblconstants. ftpfocusmode references which string or field? Do i need to create a table, tblconstants with a field, ftpfocusmode? Also, can I call this (Call ExecCommand("C:\Windows\System32\ftp.exe -ns:" & Chr(34) & scriptfolder & ScriptFile & Chr(34)...

asap 234!@ these rae the user id and password, i pass in the file after the open ftp line

The FTP path is correct since I am able to open it via WinSCP

Hi, I receive RaR and PRTV files, which i save as text files. I need to import them into Access table. Currently, I paste this data into the table, which has one field. I then use the Mid function to read this data, parse it into various fields and then append it to the final table. The PRTV...

Is my ftpfile correct? I am not sure if the cd should be followed by forward slash or not. Similarly, are the double quotes around files correct?

Hi, Currently, I am trying to use .ftp and .bat files to download files via FTP, but it doesn't execute. while my ftp file looks like ftpfile: open 00.123.4.56 asap 234!@ cd /ftphome cd /filefolder mget "RRRRR.R01" "X\destinationfolder\*.txt" quit and my batch file looks like ftp -d -n...

TIA, I need to format this date similar to 7/24/2018 8:09:45 AM The field, field4 value is PREP--20240626072323 I am using Prep_DateTime: IIf([Field2]="98C",Format(Right([Field4],14),"dd/mm/yyyy hh:nn:ss")) but it is incorrect. What is the format for General date?

No extra characters after that. That is how the data comes in always.