Is there a limit in retrieving foxpro file using VFPOLEDB ??

**ck9663** · Aug 19 '08, 05:18 PM

Code:

 select dbf.*, 'fromfilename' as recordsource into x
 from OPENROWSET('VFPOLEDB','c:\my\full\path\';'';'',
'select * from mytable') dbf

I have 2+Million records on the dbf file and I'm trying to upload it to a SQL Server table.

I'm getting this error:

Cannot get the current row value of column "[VFPOLEDB].fieldname" from OLE DB provider "VFPOLEDB" for linked server "(null)". The provider cannot determine the value for this column.

The funny thing is, the same code works for 100,000 rows.

Is there a better way of doing this? I need this automated as part of a process.

Any idea?

Thanks...

-- CK