opening general field containing binary data

[TheWizard78]

Hi gang.

I have a data transfer to do. The source is a MDB access file. I need to convert one file in it to DBF. After I create my DBF, it contain a FPT file for the general field. When I browse my table and try to access my general field, I get error 1420 in VFP. I really don't know what to do now. I think it's a king of RTF inside the general field. Even in access, I'm not able to see the Binary data of this field. Do someone have a solution for me?

Thanks

Robert

 

[DSummZZZ]

What does the data within the general field consist of?
Did you get it from someone else?
If so, you may not have the the same application installed on your computer that the originator of the MDB table had installed.


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[TheWizard78]

Hi Dave,

I think my data are RTF. I get it from an Office who want to convert their data to DBF, FPT.
I don't have the application using this database MDB.

According to theses info, can I do something to convert it?

I have open the FPT with WinHEX and I'm able to read the text, but it's not safe to convert 175 000 record with the text include in Winhex. Some client could have the wrong information...

Do you have an idea?

Robert

 

[DSummZZZ]

'Fraid not.
If you were to install Access and whatever you need to extract the RTF data, you may be able to do it.
Using OLE/ODBC and VFP though, I'm not sure what would be required to get the data out.

Maybe someone else can help.


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[Mike Lewis]

Robert,

One way to do this would be to create a remote view in VFP, via an ODBC connection to the Access database. The view will contain a field which will hold the binary data. If this data isn't immediately visible in VFP, you can copy it to a variable (one record at a time) and then use STRTOFILE() to copy the variable to a file.

I don't know if that will work with Access, but I've used the same approach with SQL Server data and it works fine.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My sites:
Visual FoxPro (www.ml-consult.demon.co.uk)
Crystal Reports (www.ml-crystal.com)