step1. copy the table in another folder.
step2. open the table
step3. go to table tab.click on 'Properties' tab.then click on 'Modify' button.
step4. insert a new field in the table.Datatype should be character and length should be maximum i.e. 800 or 1000 something like that.
step5. From window tab click on Command Window
step6. run this query after modification as you need.
update tablename set newtablefield=memotablefield
tablename=your table name
newtablefield= name of the newly created field in the table
memotablefield=name of the memo field in the table that need to be exported.
step7. From file tab click Export. Then in the export window give Type 'Microsoft Excel' .Give or select file name in 'To' textbox and press ok button. You will find your desired output.
কোন মন্তব্য নেই:
একটি মন্তব্য পোস্ট করুন