Search results

i'm in the process of debugging code in vb which implements sql strings, having upgraded to access 2000/2 and have noticed that the whilst the sql queries are doing there thing correctly, the sort order of the tables is quite different although the sql is identical - it appears that 2000/2 is...

help! (again!!) i've noticed that under access 2000/2002 select into queries are giving integer values where previously they were double precision, which is messing up my results in a major way is there an easy work around or do I have to change to using a create table (specifiying the...

Hi, I'm trying to import csv files which have a header of three lines, the third of which contains the column heading names, the other two are either blank or contian the file name info. How do I import the file correctly so that the data is all in the right columns and I don't have to import...

Hi all, first time here! I've just been upgraded at work to access xp from 97 and notice that, in my vb programs where I use strings to fire off sql to access, the WHERE variable = NULL no longer works and I have to change them all to WHERE variable IS NULL is this correct or have I messed up...