Is there any way (wizard or otherwise) to override this? I changed the table fields in the wizard by selecting create table and increasing their size, but then I get a buffer exceeded warning. Is there a way to do this so the data is not truncated? (field size doesn't exceed 1500, three fields in row)

import to access, then to sql. problem solved.

If you are trying to transfer the data to Excel, there is no way to do
this. 255 characters is the limit for a cell in Excel.

Rand
This posting is provided "as is" with no warranties and confers no rights.