Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fields' names converting Excel into DBF
Message
 
 
To
13/09/2006 10:12:13
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01153213
Message ID:
01153317
Views:
27
Well, importing is easy - just use xlXMLSpreadsheet constant in the SaveAs command. However, the XML output is quite complex. We may try to load it into table using XMLAdapter... I haven't done it before, but I saw several threads here discussing this.

>hi,
>thank you for reply,
>Another idea - save as XML and then convert XML to DBF... ??? how
>
>mean VFPcode.
>
>>>hi,
>>>thank you for reply,
>>>
>>>i try your code before , it works, but with one problem
>>>
>>>i have field (arabic data), i see it as rubbish (remmeber),
>>>
>>>via Mr.Sergey Berezniker code i can solve this problem(arabic fields)
>>>
>>>thanks alot
>>>
>>>m.qasem
>>
>>Yes, I remember. How are you exporting Excel file now? Do you use Append from and then change table's structure?
>>
>>May be you can save as TAB Delimited and then append?
>>
>>BTW, nobody really helped on Arabic problem... I posted a thread here before...
>>
>>Another idea - save as XML and then convert XML to DBF...
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform