Text to DBF

This was a simple task in the days of DOS. (I don't know how much things have changed.) All you needed to do was insert your desired field names on line 1 and import the file. You could specify the data types (alpha, numeric, date, currency, etc.) during the import process; field size was fixed by the spacing.

The only script I ever used on such a file stripped out the spaces and converted it to comma-separated data. During the import I could then specify all field attributes, including length.

If I'm correct in assuming that you mean you want to import from a text file to a database, there are generally very easy ways to do this.

If it's MS-SQL 2000 you are importing to, open Enterprise Manager, use the tree-view to select the database you want to import to, right-click the database, select import data, and follow the instructions in the wizard.

If it's another database, there is probably a similar method, but you'll have to check the help files for it (or get an answer from someone other than me), since I'm not familiar with them.

First create the file structure

[i]create (file)[/i]

then append your data to it

[i]append from (file) delimited with blank[/i]