Search results

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.

try shift-f2 with your pointer on the replace command. it brings you to where it is defined. it should open the object browser. when you click on the blue VBA text. It would show the DLL it uses for this particular command.

Yep, doesn't give a specific answer to my question. However in the code i saw this little piece of code CurrentProject.ImportExportSpecifications.Item(OldName) When you see .Item, usually .Add is also available. And yes, there is! I need to try something like this...

come to think of it, even the commands might require a semicolon instead of regulars comma's. I mix them up sometimes. "SELECT Replace(Field1; 'ing'; 's') AS TestOut FROM tabTesting"

One of the default references is VBA. Otherwise even "If" is a dirty word. It ofcourse shouldn't crash but give you an error message when you are using a function which doesn't exist. Perhaps your database is corrupt. try Compact & Repair. By the way, you could try this: "SELECT...

Isladogs has a lot about IMEX specs but copying it to another database is not among them. Perhaps i can use a database template in which the specifications are incorporated and copy that database to a new name.