Crosstable from ODBC or OLE DB source

[#1]

The crosstable option is not available when loading a table from SQL Server via ODBC or OLE DB.

Why is this ?

What would be a workaround ?

[Oleg_Troyansky]

Crosstable is not part of the wizard, but the functionality works exactly the same way. The following prefix goes before your load statement:

CROSSTABLE ( AttributeName, DataName, <Number of Qualifying Fields> )

You might have to first load from the database and then reload "Resident" if the preceding load doesn't work for some reason...

[bengan74]

That helped me a lot! Works like a charm!

Thank you!