Sybase Import failure Invalid column name 'AS'.

[PaulReuben]

When trying to import database tables from an existing Sybase database I am getting the following error:

[Sybase][ODBC Driver][Adaptive Server Enterprise]Invalid column name 'AS'.

I am importing using ODBC and I have a System DSN setup with a packet size of 256.

The tables are being created in the Data Model but only the table names and indexes are being imported. There are no columns or foreign keys.

Can anyone guide me as to why this would be failing? Any help would be much appreciated.

[Geert Bellekens]

Well, do you have columns named 'AS'?
I can imagine that would cause some problems as it is a reserved word in SQL

Geert

[PaulReuben]

No there are no columns named "AS". I doubt that this would be allowed and I am trying to import from tables that currently exist on a Sybase database. I am guessing that the error is being thrown by the ODBC driver so therefore the resolution would probably be in how the ODBC Driver is configured.

Any ideas?