Import comma delimited file

[chuckcou]

I know this has been talk about before. But I did many searchs and could not find out how. What I want to do is:

[color:red]Goal>

Open a comma delimited file

and import it into one of the database. And repeat this for two other comma delimited file. I am manually doing it right now. It bites

The problem is, how do I make sure the import has the right field aligned with the correct field in the database.

eg. comma delimtted file= Chuck.txt

"Name", "Dog", "school"

database= info.dbf

fields>

Persons Name

Persons Dog

Person Hightschool

How do I make sure Name=Persons Name and Dog=Persons Dog, etc.

Then I need to loop it for address.dbf with a different delimited file.

Thanks for your time on such an easy problem.

Chuck

[Lee Smith]

I take it from what to say, that the file is not giving including the blank fields when they occur, and therefore, the fields don't always match with the import?

Without seeing an actual sample of the data, there isn't much we can suggest to help, except maybe you might try and correct the problem at the point of creation, or with a text editor or excel prior to importing it.

Lee