Search results for query: *

Sorry, I mistyped. And how do I do this??? I also tried to take a look at the Replace() function but in my helpfile (Acc 2000) there is nothing in it Thx Koen

Hi Lupins46, Thx for your answer If I run this as an update query, the value 6.14 is updated to 614 instead of 6,14. I'm I doning something wrong? Regards Koen

Hello, I have a Access db, in which I import a textfield. The Field Value contains the value eg. 10,800.00. I want to replace this after importing the file in 10800.00 Can anyone help me with this. At the moment I'm using manually find and replace. Rgards

Thx Wolluf got it running and working!!!! regards, Koen

Thx Wolluf, The import is running by a macro, so that's not a problem. Do you have any examples about this? regards Koen

Hello, Can anyone tell me if it's possible to make a script that opens a database, import a textfile, zip the textfile, move the zipfile to a directory and than delete the textfile. The textfile,zipfile, database and directory names are always the same. I want to click on the script so that...

Macintosh, Ok, but please tell me how 2 do it. The easy part is dividing one table into 2 tables. But how do I setup Impromptu???? regards Koengi

Thx for your reply. A bit strange cause 2 weeks ago I created one of 129.000 rec's from Access. If I split it into 2 tables, can I still create one cube???? Regards Koengi

Hello, When I run a cube I'll recieve the error TR0109 "Couldn't read source date" I'm using a iqd file and an Access table. When I run the cube with 100.000 records, there's no problem, if I run it with more records, this error message appears. Anyone got an idea?? Thx Koengi