Citadel data access from MS SQL Server?

[Straatvark]

I need to move Citadel data into SQL Server. Currently Query it into Access via ODBC and then import into MS SQL Server with a DTS package.

Can the ODBC source be queried directly from MS SQL and what would the syntax be. (Sample code would be really helpful 🙂

Thanks, gert

[Ricardo_SR]

Hello,

Citadel is SQL compliant. Meaning that you need to use SQL commands and you should be able to read back from Citadel.

Ricardo S.
National Instruments.