Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Import Data into MS SQL Server
Message
De
21/01/2010 15:27:59
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 2000 SP3
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01445218
Message ID:
01445302
Vues:
64
This message has been marked as a message which has helped to the initial question of the thread.
>Hello all:
>
>We are converting a FoxPro data load program to be all MS SQL Server.
>
>We presently use the FoxPro command:
>
>APPEND FROM "f:\narbook\nar010610.txt" TYPE SDF
>
>To get the text file into a foxpro table.
>
>The foxpro table has several fields that are all character.
>
>What I need is a way to load the same data into a MS SQl Server table of the same structure.
>
>We have tried several methods and all seem to have issues getting the data into the correct field.
>
>Any help or direction would be appreciated.
>
>TIA

Check Message #886662 for a sample.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform