Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Some field information lost in import-export procedure
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00448608
Message ID:
00448673
Vues:
9
Hi Peter,

If all your fields are always character, then you can just manually set up a table and import the data (assuming that there are 3 fields to import):
select 0
create table ImportData (field1 C(80), field2 C(80), field3 C(80))  && etc ...

append from (getfile()) type delimited  && gets the data into the table

browse  && just displays the results of the import
>Hi Andrew
>
>So is there a way to set a default field size for use on all imports? Let's say 80 charc. If there is then I can skip going through every field size adjustment. Some of the files I import have numerous fields which I generally import as text fields.
>
>Also do you know of any program that can take a tex-delimited file, scan it for field size based on characters per field, and then export the file as a dbf?
>
>Thanks


If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?


From Top 22 Developer Responses to defects in Software
2. "It’s not a bug, it’s a feature."
1. "I thought I fixed that."


All my FoxTalk and other articles are available on my web site.


Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform