Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing from Excel
Message
From
19/07/2002 05:34:30
 
 
To
19/07/2002 03:25:55
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00680330
Message ID:
00680339
Views:
25
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform