Jump to content

Import comma delimited file


This topic is 5762 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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 :bang::bang::bang:

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

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 5762 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.