Importing vantage tables into SQL

Yahoo Archive
1
Good afternoon all.

I've been trying to import some tables from Vantage 6 into SQL Server via
ODBC using it's DTS wizard. The wizard previews the data but when I try and
import it I get an unspecified error from the provider. I know the ODBC
connection works because I can use it to link to access. I've even tried
using a query to just pull out a couple of fields but I still get the same
error.

Any ideas?

Thanks in advance.

Martin Horton
Assistant Group IT Manager
PRD Holdings Ltd
DDI: 01902 639187

Mobile: 07770 618909



[Non-text portions of this message have been removed]