For the record, just in case someone else is going through this
I solved this copying the table to excel using this
http://www.sweetpotatosoftware.com/spsblog/2008/09/30/UsingExcel2007FileFormatsInVFP90.aspxThen I used the excel 64 bits oledb driver to import the data and thats all.
Regards>>Yes, I know. What I'm looking for is how tho create the SQL Server table structure from a cursor structure.
>>>>Hello all
>>>>I'm updating my reporting app. I use to make a temporary DBC to store report data and thend automate excel to make the reporting. but Excel 64 bits doesn't recognize my OLEDB VFP driver. I want to work with Sql server tables instead to avoid the problem, but I should create temporary tables from very variables memory cursors. Is there something to create a SQL server table from a VFP cursor?
>>>>Regards
>>>
>>>There is nothing direct, but you can create a table and send data from VFP to SQL Server
>
>Using AFIELDS generate CREATE TABLE statement. Alternatively, you can convert VFP cursor to XML and send this XML to SQL Server and parse it there.