Search results for query: *

That absolutely resolved it! Thank you so much. If you have time, could you explain WHY that worked?

I'm trying to call a batch file that uses SFTP. If I double-click the batch file, it FTP's successfully. But when trying to call that .bat through VBA, I either receive strange errors or no error at all. Method: lShellResults = objShell.Run("R:\directory\SendSFTP.bat", 7, False) Results...

That was exactly it! The HoldingsException needed "" around it!! Thankyou so much. None of the examples I looked at online had quotes there so I didn't think I'd need them. Very good!

DoCmd.TransferText acImportDelim, HoldingsException, "tblHoldings_Exception", _ "\\Folder\Reports\" & "Holdings Exception Report-" & today & ".txt", True rstC.Open "select * from tblHoldings_Exception", conn, adOpenDynamic, adLockOptimistic Do Until rstC.EOF...

I've checked those last 2 fields as "SKIP" in the Advanced portion of Import Table and saved it. Still receiving this error though: "Field NoName doesn't exist in table tblHoldings_Exception" All fields are mapped and accounted for...but I think for some reason those 2 extra commas are still...

Yanno, I'm not familiar with that specification. I tried to search google on it but couldn't come up with anything solid. Could you provide anymore detail?

I'm importing text files that are comma-delimited. Unfortunately, the software that creates these files drops 2 extra commas in at the end of each line. This throws off my import and Access sees a "No Name" field there. What's the best way to delete these commas? Is there an RTrim that'll read...