importing data into MS Access 2003

[Shift838]

I am having issues importing an Excel document to Access 2003. I have made sure I have all the colums named the same and in the same locations as the Access database.

I am wondering if the issue is because of the True/False values the access database wants. Should I have -1 for true or 0 for false in the excel spreadsheet or just simply true or false? Also does all the fields need to be populated in the excel spreadsheet? if not what will the default value be for the true false fields?

 

[blanchj]

Chris you are right. The data in the spreadsheet should contain -1 and 0 if the access field is a yes/no field. The default should be 0 and is false(no). By default the empty cells should import as 0. If you import from excel with a data type of numbers, and you then convert from number to yes/no field in access, then it will warn that the field size property may be different, but it should convert o.k.