>I have a data file I download from a mainframe into a VFP dbf.
>
>I want to copy the structure from that dbf to a new table in SQL 2000.
>
>Is there a reasonable way to do that?

* with data
SELECT * into myTable
   FROM 
   OPENROWSET('VFPOLEDB', 'c:\myPath\myDatabase.dbc';'';'','select * from myVFPtable')

* w/o data
SELECT * into myTable
   FROM 
   OPENROWSET('VFPOLEDB', 'c:\myPath\myDatabase.dbc';'';'','select * from myVFPtable')
   WHERE 1=2

Is a dirty way.
Cetin