Recent content by dsub42

O.K this is driving me loopy now.... when importing a column from paradox which is TRUE / FALSE....(and includes null values) Access imports TRUE as -1 , No as 0, and the NULL values as -1 also.... What the hell is that about, I would understand if the nulls were imported in as False, but...

do you know what function i could use for a colum called "starttime" to change... 30/12/1899 07:34:00 .... to .... 07:34:00 considering the data in every field is formatted the same way, and some cells contain a null value?

ok another problem im having is in a field that is importing time(field type) from paradox, ... in access its adding a date to the time of .. 30/12/1899... any idea?

o.k, how can i specify for that column not to import the data as yes/no data type.. Im importing from a paradox table, it is 70+ columns of which about 5 are true/false in paradox, access interprets them as yes/no.. to import i literally go to external tools > other > paradox > select the...

The reason for nulls is as follows.... a field in the data base indicates a person having training for something... the data in this field will be either true or false if it is known, for some people it is not known and it is important to the business that they have that distinction. True /...

yes, but it doesnt remove what should be the null values

Hi I am using Access to import a table from a paradox database There are several colums which are boolean values, these contain alot of null values in the source table and it is important that I keep them in the acces table, However, when import the table, access replaces all of the null...