Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Batch update to SQL Server??
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01545010
Message ID:
01545014
Views:
54
>>I have a cursor that has about 80,000 records in it. I need to upload all of the records to SQL server. Is there a quick way to do this in some sort of batch?
>
>I think sending it as XML to SQL Server may be one of the options. Another option is to save as CSV and load from CSV using Import/Export wizard

hmmm...I will take a look at doing it as XML. Don't want to use the wizard as this is going to be part of a program that runs every night.
I'm just trying to find a way to make it run quickly :)
ICQ 10556 (ya), 254117
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform