Does anyone know what the best way is to import a DAT file from a VMS system
into MS SQL Server 2000 is?

Any idea what format it might be in?

Thank you,

Rob

Easiest and cheapest way is to export the data to a CSV on the VAX and then
import the result using normal SQL Server methods.

In the past I have used various tools that supply ODBC drivers, but they
cost....

Paul

"Rob" <Rob (AT) discussions (DOT) microsoft.com> wrote

Paul,

What command would you run against the DAT file either on VMS or on the
Windows side to break it down into CSV?

Thank you,
--
Rob


"Paul Smith" wrote:

"Rob" <Rob (AT) discussions (DOT) microsoft.com> wrote

The .DAT file type on VMS doesn't imply any particular format. What program
created the file?

John Saunders