Search results

Hi guys, thanks for your replies! @ebs17 yes it is. The Bank Statements have for the first line of content always a certain structure. IBAN; Auszugsnummer; Buchungsdatum; Valutadatum; Umsatzzeit; Zahlungsreferenz; Waehrung; Betrag; Buchungstext; Umsatztext You are right that maybe if someone...

Hi Eberhard, Not really sure what you mean with that sorry? At present I get the fullpath and filename with this procedure Private Sub btnBrowse_Click() Dim diag As Office.FileDialog Dim item As Variant Set diag = Application.FileDialog(msoFileDialogFilePicker) With...

Thanks, unfortunatelly same issue when I put it into a higher folder .( to reduce the path and file name

Hi Gasman, as soon as I use a filename as mentioned I get the same error. "C:\Users\Albert\Documents\AJL\CSV_Daten\Test\umsaetze_girokonto_AT221111011010110011_EUR_2021_10_13_08_17_32.csv" Error "C:\Users\Albert\Documents\AJL\CSV_Daten\Test\01-03_2016.csv" Works So what could the issue...

Hi guys, I am back and trying to work out CSV Import. First question still remains why I can not import a File with a name like following: "umsaetze_girokonto_AT221111011010110011_EUR_2021_10_13_08_17_32.csv" If I run this Code below In the Imidate window "Call...

Thanks CJ, I will look into that.. Cheers!

Hi Eberhard, thank you! I will try that many thanks! Cheers

Sorry Pat, I am a little lost right now :( You would not have an example of how to get the data out of the csv file as requiered by any chance? Cheers

Hi guys, @CJ_London well I would like to include the BankName so to speak :( so maybe it needs to be like 2023_01_04_12345.csv Would that be ok? And what do I supose to use like can I somehow open the file to check the dates and soforth as discriped withouth any issue? @Pat, well when I have...

Hi guys, many thanks for your help! To clearify things to me! Unfortuantelly the next few days I will not be able to process all your help but will do a soon I can and get back to you! However I do have just one question which would be in my case the first step what needs to be done. The bank...

Hi guys, many thanks to you all for helping me and giving me good tips and hints! I will go through those and get back to you! Really appreciate your help! Cheers

Sorry Gasman what do you mean? I did not say that anyone gave me this code. Just was trying out.

Hi CJ, still some issues with insert into statement Sub testNewInsert() Dim db As DAO.Database Dim rs As DAO.Recordset Dim fpath As String Dim fname As String fpath = "C:\Users\Albert\Documents\AJL\CSV_Daten\Test\MyTestFiles" fname = "TestDaten.csv" Set db...

Hi CJ, many thanks!! Well now I am getting there I will try to sort it further and get back to you! Cheers

No I havent.. ( But I am trying right now but got already an issue.. Currently I got this below.. Sub TestDAO() Dim rs As DAO.Recordset Dim fpath As String Dim fname As String fpath = "C:\Users\Albert\Documents\AJL\CSV_Daten\Test\MyTestFiles" fname = "TestDaten.csv"...

Hi again, not sure if I suppose to stay in this threat or not but I am trying to keep it in here. I guess if it is wrong you well tell me ) I was trying now to use ADODB to refer to my folder and one TestCSV File below is what I got so far. But I am not sure how to get that into the my...

Hi Eberhard, thanks for your reply! Ok I understand.. will need to look into that a bit more. But thanks for pointing that out to me! Cheers Albert

Hi Pat, thanks for your answer. The way I have done it in the past was either from Excel or from Access using the Excel Libary. Most of the was retrieving information about that file what Bankaccount, FirstDate to LastDate and created a Filename like: 124514_JanToDec_2020.csv" and save that...

Hi Pat, Hi CJ, thanks to both of you for your replies! Unfortualtelly I am not to sure about that either .( But it is a Bank Statement I am working on and in the end it gets importet to Access. So some issues or perhabs where I am not to sure what the best approach is. 1. I like to be able to...

Ok thank you Minty! I will try that! Cheers Albert