Search results

The remote location is ftphome/DeliveryOrders. Also, I know the command to execute ftp is ftp -d -n -s:c\folder\dtccwinscpfile.ftp I am aware to pass winscp within as Shell Command but not sure how to execute it manually

I changed it to FTPRCV but still unable to download

I did try just "get" I modified the line open 10.xxx.x.xx 2852 pwd3478!# cd ftphome lcd DeliveryOrders get 202406280102.FTPRCV C:\Reports\DTCC\dtcc but it did not download

I am not sure why nothing is being written to the log file. The Call Shell(strSFTPDir & "winscp.exe " & strQuote & strCommand & strQuote, vbNormalNoFocus) executes without errors. Totally clueless!

it doesn't give any errors. I will try to use log

Hi, I am trying to automate my winscp script to download files froma ftp server This is my winscp code and text file (courtesy - Pat Hartman). Private Sub Command1_Click() Dim strQuote As String strQuote = Chr(34) Dim strSFTPDir As String strSFTPDir = "C:\Program Files (x86)\Winscp\" Dim...

This works for one condition. There are derivations for others, such as for 36B it will 50000000 (EST Settle AMT) and 98A = 20240626 (EST Settle Date) and so on. I am trying to use IIF or equivalent

I get the data from a text field import. There are derivations for others, such as for 36B it will 50000000 (EST Settle AMT) and 98A = 20240626 (EST Settle Date) and so on. This is an hourly data. I read the data into another table and delete the original table data to receive next hour data.

I have a table with data as below I need a query which would derive the fields from this data such as, MessageType : IIF(Left([F1],4=":20C"),Right([F1],10)). I need o get the value as ICF0000325 (the second row) But it is giving #Error TIA

I was able to follow your suggestion and was able to read the complete contents of one text file into the table Dim strFilename As String: strFilename = "C:\PG\BC2\TCC\20240626060103.txt" Dim strTextLine As String Dim iFile As Integer: iFile = FreeFile Open strFilename For Input As #iFile Do...

I tried manually pasting the data into my table and use this sql which formats the data correctly SELECT Mid(message,1,2) AS [Message Type], Mid(message,5,6) AS [Timestamp], Mid(message,95,1) AS [TYPE-OF-08-RESPONSE], Mid(message,97,8) AS [DO-OUT-DLV-PART-NUM], Mid(message,107,9) AS...

My field is also Long Text.

It still imports data from all files in the folder but only until A1010307300000038824, which is the constant first entry in all files followed by other data inside are different.

I am not sure where that is coming from since the data in the text file is A1010307300000038824 2024178000010000038800000380 O 0000038824-000001S513000000388 06055JFD6OM 000000000 * 85173 01965137 SB 030000000 533SEG5 Is there a way to there are several text files in the folder and the code...

No. This all is in a single row A1010307300000038824 2024178000010000038800000380 O 0000038824-000001S513000000388 06055JFD6OM 000000000 * 85173 01965137 SB 030000000 533SEG5. I need all this data to be dumped in one field (Long Text). But it truncates after A1010307300000038824. It gives a...

Apologies, I was trying with "DoCmd.TransferText acImportDelim, , "tbltcc", objFolder & "\" & objFile.Name, False and it truncates. But Using your code of sqlinsert, I got an syntax error, which I have replied in your response. It gives a runtime error '3075' syntax error in string in query...

It gives a runtime error '3075' syntax error in string in query expression "A1010307300000038824'.

yes, It is Long Text

I changed it to False and it imports all files but it stops after "A1010307300000038824" and does not import the rest of the data