Extracting contents of Memo field from Access field via VBA 1

[Actuary2B]

I have a FoxPro database that was imported into Access (we don't have FoxPro). The resulting table contains 100 records and three fields: A, B, C.

Field C is defined as a "memo" field and contains lots of text. I need a way to extract the contents of each of the memo fields for each record into, say, ideally, a flat file.

I am proficient with VBA for Excel but I am a fish out of water with the Access object model.

Any basic help would be greatly appreciated. Thank you.

 

[PHV]

Simply export a query ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Actuary2B]

Sounds simple enough. Could you please elaborate more? Thanks.

 

[traingamer]

Create a query. e.g. qry1

Select cola, colb, colc from tbl

Single click (select) the query. ChooseFile->Export from the menu. Choose the file type (e.g. text) and hit the 'export' button.


Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[traingamer]

And count your lucky stars if you can actually get all of the data from a foxpro memo field.

 

[Actuary2B]

Thanks! That was great. I was looking for a much more difficult solution but this works.