>From: Lee Messenger >Has anyone developed any processes to natively >read '.dbf' type files >from within Universe basic?
I wrote one for Universe back in 1995 and improved on it up until 1998. It converts dbf files, creates an include file which has a DIM and equates for a matrice to use the fields with their names. It also creates dictionnary elements for the converted file using the dbf headers. It does not convert .dbt files. I based it on a dbf file format description I found on the Internet back then. I also made it able to convert fixed-length files, delimited files provided a header is defined for the file. The program asks several questions the first time it converts a file. It will remember the answers for subsequent conversions. It was tested over several data conversions I did overseas. The reason I had the tool produce an include file with equates is that sometimes the customers would provide me with .dbf files for the live conversion in which some fields were sometimes in different positions from the test data files I was given to develop the conversion programs. The equates includes made it possible for me to manipulate the fields by their names (all I had to do is recompile the program which used the includes). The program also generates a tab-delimited excel file with the name of each column on each line with a description of the data type. This was initially for me to document what the fields were for. __________________________________ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
