Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing problems
Message
 
To
25/09/2002 15:30:46
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00703929
Message ID:
00707968
Views:
39
Dragan,

I have found a ´better´ solution. What I have noticed is that if I copy the text from Access to VFP some characters are converted. If, however, I copy the text from Access to Word and copy and paste it from Word to VFP all is well. What I have done now is selected all records in Access, paste them into a Word-document (so it´s in a table). I then create a Word.object in VFP and move along the file copy the required cells into the clipboard and put them in an instance of the RichTextControl box. The contents of the control in then writen into a memo field preserving all information.
I guess this is a lengthy way of doing this but it works...
My customer is very happy with it.

Thanks for you advice.

Regards,

Ron Brahma

>>Dragan,
>>
>>I would like to try an other option. At this moment I create an instance of Access for the export. I want to try to open the database with Ado and copy it data directly into the VFP table. This means I'm not exporting/importing data anymore....
>>If this does not work I will look into your suggestion.
>
>The conversion may still happen while you copy. Look at the data beforehand and make sure you see all three vocals which don't exist in 1252 (long i, û and ö - should be í, õ and û if you're watching this page as ISO-8859-2). You may still need to set the locale on your box, and have a
>
codepage=1250
>in your config.fpw, so that the new table which gets created has that codepage.
Previous
Reply
Map
View

Click here to load this message in the networking platform