I want to create Transform Data Task with a VFP free table as the destination.
The table is not in the dropdown selection. I know the table exists because
I can see it in the folder.

I am able to add an Execute SQL Task with the same VFP Connection and query
the missing table. I get the expected results.

I would appreciate any help/advice on how to resolve the probelem of the
missing table.

Thanks in Advance

Hi Karen,

I assume you're using SQL2K, and I'm sorry I don't have it installed on this
machine.

How are you connecting to your Fox tables? OLE DB? ODBC? You can get the
latest FoxPro and Visual FoxPro OLE DB data provider from
msdn.microsoft.com/vfoxpro/downloads/updates.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden (AT) msn (DOT) com www.cindywinegarden.com


"Karen Hodge" <KarenHodge (AT) discussions (DOT) microsoft.com> wrote