Importing/Exporting A Precise DBF structure

[efinnen]

Ok here's My scenario. And I'll state the standard disclaimer Any Help and/or suggestions would be greatly appreciated.

I have numerous DBF's up to 100 at a time in various folders.

I need to import them all, change some field types and definitions and then export them to a precise dbf format. Specific fields of extact lengths and numeric values with no decimals.

So Here's where I'm at

1) I have a batch process to import all the dbfs.
2) I have queries to make the changes I want, and then I can export them.
3) The data is right (sorta...). All the numbers are exporting to 5 decimal places (not wanted) and a standard width of 20. Which won't work correctly for my end product.

So anyone know how to fix the numeric sizes precisely??

Any suggestions would be greatly appreciated.

Thanks
Eric

 

[MichaelRed]

Not 'Precisely', but I would SUGGEST that you can change the process to place all the changes into Ms. A. Tables, using the correct field types - then do the export - of the Tables.

MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[efinnen]

Michael

Thanks for the help, and you brought to my attention one step that I accidentally left out of my process. The queries are actually Append/make (I've tried both ways) queries which then populate thetable and I attempt to export the table and not the query.

-e