help!!有关用 OpenDataSource或openRowSet 从FoxPro2.6 导入到sql2000中的问题。高手帮我!!
说明:必须用sql语句实现,
我试了
SELECT * INTO [dbo].[jck] FROM openrowset
('MSDASQL','Driver=dBase 5.0;SourceType=DBF;SourceDB=C:\Documents and Settings\yang\My Documents\dbf\dbf\jck\','SELECT * from [jck.dbf]')
和
SELECT * INTO [dbo].[jck] FROM
OPENDATASOURCE ('Microsoft.Jet.OLEDB.4.0', 'Extended Properties=dBase 5.0;Data Source=
C:\Documents and Settings\yang\My Documents\dbf\dbf\jck\')...[jck.dbf]
都不行,请各位老师兼高手帮忙呀。在线等。