export to xls

[vlad simion]

Hi again,

I posted yesterday a message regarding an export to excel. No one has any
sugesstions about how to export a string variable to an xls file via ODBC
driver. My problem is that it only saves the first letter of the string and
not the whole string.

Here is part of the export syntax:

save translate
 /connect= 'dsn=excel files;dbq=c:\documents and
settings\ay08418\desktop\data\test.xls'
 /table=!quote(!n)
 /type=odbc
 /replace.

Thanks again!

Vlad.



--
Vlad Simion
Data Analyst
Tel:      [phone]