Extracting data for non access users

[dbero]

Hello:

Frequently I export access tables to Excel for others to review the data. However I now have a table that has a column that contains 100 or more characters. When exporting to Excel, it truncates the data because cells have a limit. Does anybody know an alternate export format, other than reports, where all the data is exported and yet a non access user can access the data electronically.

Thanks!

 

[PHV]

Have a look at the DoCmd.OutputTo method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886