Export a table with all data 1

[sharpie]

I am currently trying to export a table that includes a memo field which is linked to another table. If I view the table in Visual FoxPro6 or Access97 it only contains the text 'memo'. However, I can see the full record if I run a report or query.

How can I export this table so that it includes the data in the linked field? I would like to use Access to read it.

Thankyou

 

[danceman]

I am a little confused. What are you trying to export to?
Or are you just wanting to view data through Access?
You say you can see the memo data with a query, query through Access , FoxPro?

access has external views that can be created. Attitude is Everything

 

[sharpie]

Thanks for replying danceman,

Basically I would like a table that displays all the data.

If I just view the table in Visual FoxPro there is one field that looks like it only contains the text 'memo', if I double-click each record in the memo field the full information is displayed.

I need the full text in the memo field to be displayed along with the other fields.

Any help would be greatly appreciated, it's driving me crazy!

 

[danceman]

That is the way memo fields work. Use the Memo field type to store blocks of data. The Memo field contains a ten-byte reference to the actual contents of the memo. The actual size of memos, however, depends on the amount of data you enter into them. Data from Memo fields of records in a table are stored in a separate file with the same name as the table and an .FPT extension. Memo fields are limited only by the amount of available disk space.

So, if you want to display the data on a form or grid use the EditBox Control. Because the data in the memo field is of undetermine length the editbox was made to allowing scrolling and editing of the text. You can use this on a form or in a grid. Attitude is Everything

 

[sharpie]

OK, I understand.
I am doing this as we are converting an existing fundraising database to Raiser's Edge which uses SQL. For conversion purposes I need to provide them with all our data in tables. Most of them have been converted without a problem except this one.

Is there any way to convert this memo field to an editbox? There are approx. 750,000 records in this table and it is pretty vital!

Thanks for your help.

 

[rgbean]

The best available technique for the Export with Memo fields (at least that I've found) is the code in

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q241424

- "HOWTO: Export Memo Fields with Other Field Types to a Text File (Q241424)".

Rick

 

[sharpie]

Excellent, problem solved!

Thanks for your help.
Chris