>Hi Guys,
>I am trying to import something from excel into an exsisting DBF. Whats the simplest way to do it? I have made sure all unique keys are correct. I also have a logic field in that dbf, is there anything I have to do specially to match the datatype? I have put .T. in the excel file as true, would that work? I have never done this, hope someone can help me out~ ^_^
>thanx
>^_~
>Tom
Tom,
Logical fields in excel are TRUE or FALSE
I've create a spreadsheet with a1 TRUE b1 FALSE, and a2 FALSE b2 TRUE
IMPORT FROM c:\tmp\test.xls TYPE XL8 SHEET "Sheet1" makes the two columns (a and b) logical
Maybe this can help you get started
Gregory