Search results

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.

Db guy, thank you 😅

Oh ok :) thanks

I sent the simple part of my database and my project included the sample csv files. So what we should do if we are importing files?

I'm attaching my project and some sample files if that helps to understand what's happening exactly. By the way I am thankful for your time to concern my case.

I removed that from main code , I cleaned all modules and add new one, changed the function as Public Function, and saved as with your sign :) But still that is not changing the file nime, (Runtime 3011 error) 🙈