import and seperating dbf file

[Storm3]

I am trying to import a dbf file. My only issue is trying to seperate one column to many. This column uses carriage returns as a seperator and I have been unable to split the column I am attaching a sample to this post.

Any advice GREATLY APPRECIATED!

David

 

[ed333]

I am not sure what problem you're having. I d/l your file, created a new blank database and imported your file (as a DB 5 file type), and got a table that had many, many fields.
Is there a specific field you're having a problem with?

Ed

 

[Storm3]

dbf file

Hi,

The field with the name and address. I would like to separate the field into several columns and I am not that well versed with sql to accomplish this.

Thanks for the assistance!

 

[neileg]

Try searching these forums for 'carriage return'. There's quite a bit on dealing with these and you might just get what you want.

I haven't worked this up, but you can use Instr() to find the position of the first character you specify, so you can use Left() and Instr() to get the first chunk of the address, then use Mid() to get the next, and so on.

I presume you have an upper limit on the lines in the address, else you won't know how many fields you are looking for!