Recent content by Ocicek

Hello Majp I hope you're well since we didn't see communicated:) After working with this code for a long time, my friends warned me about something. The problem is, the code skips importing some files in the folder. It imports the file it skipped on the next attempt, but skips the file it...

Thank you @The_Doc_Man .. I'm working on that.

Hello All I have a code loop through all excel file in a given folder. But I have problem if some files opened from that folder the loop is getting crash. (With this code excel files opening as hidden on another instances) My example code is: So Where should i add a condition in the code to...

@bastanu thanks for advice, I am not a coder and I'd like to know that we can use connection script with a txt file. and yes I had a sqlite filename textbox. So I prepared my code like that: Dim tdf As DAO.TableDef, sConnect As String Set tdf = CurrentDb.TableDefs("okumalar") sConnect =...

Bastanu I'd try to do it but I think I have to learn more about declarations and commands on VB. My connection string is like "DSN=SQLite3...

Thanks Bastanu. I'll try that immediately.

Hello friends. I have an application running on Android. The application works with sqlite database. I load the list of values to be filled in to this sqlite, then this sqlite file comes to us. I need to do the empty and filled version of this sqlite database with microsoft access database from...

Thank you dear MajP I'm also not at computer. I'll check that on first chance.

Dear MajP we are on good way to calculate more than thousands meter values and billing process on our accdb. On this thread you know we were choosing the folder and importing the csv files in to our access table. I would like to make it more flexible due to our requirements. So is it...

Finally worked (y)👏👏👏 Thank you very much !

Like this.

I did but now I got a "New FileSystemObject" definition error.

Dear @MajP I used what you posted. Bu I got Defination error FileSystemObject. Dim FSO As FileSystemObject, objFolder As Object, objFile As Scripting.File (new code) Dim FSO As Object, objFolder As Object, objFile As Object (old one) What I did missing?

Dear @MajP , dear @theDBguy, dear @drakopp, dear @MickJav, dear @The_Doc_Man dear @Isaac Thank you for attend time for my case. I'm sorry to late to checking. Because of our time zone. I'll be testing now.

It doesn’t matter. You can prefer whichever way is easy. If we copy files we should delete after import.