General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only