Recent content by Guus2005

Nice one Moosa! Perhaps you can also explain how you made that video, the tools you use and how much time it took to complete. I don't think this was your first time. Thanks!

The record length can vary from 50 to 400 characters. Which is not very fixed.

What @The_Doc_Man said is very true. Speed is relative. If you are waiting for it to happen, it takes a lot of time. The solution needs to run once a month. So that is not very often. This is a record in the output file...

I need to write about a million records to a text file. There are several ways to accomplish this. I need the fastest ofcourse. Method #1 Set fs = CreateObject("Scripting.FileSystemObject") Set a = fs.CreateTextFile("c:\testfile.txt", True) a.WriteLine("This is a test.") a.Close Method #2...

The scope of variables in a batch file is restricted to that batch file. @Gasman "Set it as an environment variable" how do i do that?

How can i use a batch file to set a variable so that it doesn't vanish after the script is done? rem File1.bat set variable1=foo rem File2.bat echo %variable1% When i run File2 after File1 variable1 is not recognised. So the scope of variable1 is only within File1.bat present. How can i...

Thanks for all the responses. I tried both solutions. With Importspecification (sql INSERT statement) and using the FileSystemObject (Open Filename For Input) I made an import specification and used the SQL Insert statement using the import specification and imported 10 files with a total of...

Here are a few sample input files. Still can't find some help page about [Text;FMT=Delimited(;);HDR=No;ACCDB=YES;DATABASE=N:\Mijn documenten\].[bestand1#csv] Any help is welcome! Thanks!

My csv inputfile looks more or less like this: 1;aap;noot;mies 2;wim;teun;vuur 3;gijs;kees;bok When i use any of the proposed code solutions above, only the first field is filled with the complete record. This is what i tried: insert into Tabel1 ([Id], [Veld1],[Veld2],[Veld3]) select...

Thanks for the input. This is great stuff! Thanks everyone!

Thanks for your reply both! @Docman you have a few valid points i haven't thought about. Size matters! No, this question and the one in April are not related. But perhaps i can combine both answers from then and now. I forgot about the IN clause of MS Access SQL. That might come in handy...

Wat is the fastest way to import 2300 similar csv files into an Access table? There is a number of ways to accomplish this. I need the fastest. Thanks for your time!

i don't want to bloat my frontend with a temporary table. I can link the csv file to my frontend but then i can't add a primary key. (Not sure if i can set an index on a linked table) In one of the two csv files i need a PK to be used as a linenumber. First csv is a reference, the second is the...

1. see post #4: Compact & Repair, I am assuming you have already tried that. 2. copy all objects to a new database hoping the error goes away 3. post a sample database describing the problem... HTH:D

This is what i type in QBF: TestOut : Replace([Field1];"ing";"s") and this is what i get when viewing SQL code: SELECT Replace([Field1],"ing","s") AS TestOut FROM tabTesting Your output is more or less the same. Try to put square brackets around the field name.