Thats what I'll do I think, but I just noticed that I will generate useless data traffic, sending to SQL Server the results I already have locally and then retrieving the data again from the server. I'm investigating about how to create a MDB or load the XML as data source for Excel..
>>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.