Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Importing large alpha fields
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01028581
Message ID:
01028640
Vues:
27
This message has been marked as the solution to the initial question of the thread.
Geoff

Natively it won't support anything that exceeds field size limitations nor will it handle memo fields.

One fast way if Excel is available is to APPEND FROM to get all the non-memo fields, then open the file in Excel via automation and read the memo cells to pull the data into the cursor.

Reading the file line my line involves some fairly complex parsing to deal with commas that may appear inside a quoted field.

>I have an import file which is in CSV format. It has an alpha field which can be up to 2000 bytes long.
>
>I thought to use APPEND to bring the data into memo a field (along with the other fields.)If I try to import it using either DELIMITED or CSV my field gets skipped if it is defined a MEMO.
>
>Is there a way around this short of treating the entire file as one string and processing each line?
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform