Search results

  1. Guus2005

    Smart Domain Functions Builder V1.0

    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!
  2. Guus2005

    Fastest way to write to a text file

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

    Fastest way to write to a text file

    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...
  4. Guus2005

    Fastest way to write to a text 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...
  5. Guus2005

    use batch file to set global variables

    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?
  6. Guus2005

    use batch file to set global variables

    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...
  7. Guus2005

    The fastest way to import over 2000 csv files

    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...
  8. Guus2005

    The fastest way to import over 2000 csv files

    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!
  9. Guus2005

    The fastest way to import over 2000 csv files

    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...
  10. Guus2005

    The fastest way to import over 2000 csv files

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

    The fastest way to import over 2000 csv files

    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...
  12. Guus2005

    The fastest way to import over 2000 csv files

    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!
  13. Guus2005

    Importing CSV files in a new to be created Access database

    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...
  14. Guus2005

    Problems with Replace function...

    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
  15. Guus2005

    Problems with Replace function...

    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.
  16. Guus2005

    Problems with Replace function...

    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.
  17. Guus2005

    Importing CSV files in a new to be created Access database

    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...
  18. Guus2005

    Problems with Replace function...

    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"
  19. Guus2005

    Problems with Replace function...

    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...
  20. Guus2005

    Importing CSV files in a new to be created Access database

    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.
Top Bottom