Two ?'s - Exporting ACCESS table to Excel and Tracking Users

[tallgaluser]

Hello,

I exported (tried to copy and pasted too)a table from ACCESS into Excel but all the text field data did not export over. The ACCESS table has two memo fields that have about 1,000 characters of text, but when I exported to Excel all of the text that shows in the ACCESS table did not export to excel. I read that excel allows import of 32,000 characters or less. Can someone tell me why all of my data from ACCESS did not make it into Excel.

Also, I would like to track usage of our database (changes,saves, deletions etc) is there anyway to do that in ACCESS 2000?

Thanks
Diana

 

[mp9]

In macros or VBA, investigate OutputTo and/or TransferSpreadsheet commands for the export to Excel.

http://www22.brinkster.com/accessory/

 

[tallgaluser]

I tried that and it exported most of it but not all of the memo portion. HELP

 

[PHV]

Crosspost thread181-1107448