sql server programming: I am trying to transfer data from Visual Foxpro Table Version 7.0 to Sql
Server 2000 through
Sql Server Query:-

Insert into mySqlTable
Select DCode,PurDate,Amount from
OpenDataSource('VFPOLEDB.1','Data Source=D:\FAST-DTML;')...DC_DASET

But following Error occured.


OLE DB provider 'VFPOLEDB.1' supplied inconsistent metadata for a column.
Metadata information was changed at execution time.
OLE DB error trace [Non-interface error: Column 'Amount' (compile-time
ordinal 16) of object 'DC_DASET' was reported to have a PRECISION of 5 at
compile time and 4 at run time].

Any idea what is the reason ?

Best Regards,

Luqman

Hi,
Try creating an ODBC connection to the FoxPro database and use Linked
server OpenQuery to perform the same operation.

Regards,
Gayathri Rau [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.