June 13, 2007 at 1:05 pm
I am a newbie to SQL and am trying to export a database to excel. I have been successful at doing so, but there are two M or Memo fields that I would like the data contained in them sent as well, but I cannot get that data to go over. Please advise.
Rob
June 14, 2007 at 11:21 am
I will assume you are exporting a table. Script the table to Select, add a column with the datalength of the memo field, sort by that field in descend order. Export using the query so the first record is the one with the longest memo field.
If your memo has commas, tabs or any other delimiter, layout the fields so the memo is the last field on a row.
June 14, 2007 at 11:41 am
I am using Visual Fox Pro 8.0. I can get the Memo to export to a datebase file, but not excel. It tells me that there is no data in the table. It also will not let me export any other column with the memo colulmn, it only sends that one.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply