We have a MS Access 2000 database file with a Table that contains a field with numeric data. The table is imported from a delimited text file. The problem is that after the table has been imported we change the attribute of the field to be 2 decimal points only. (The imported table contains various decimal point places - ie., one might have 6 decimal places, one might have 3, etc.,). Once we've done some work on the table, then we need to export it again as a DBASE IV .dbf file (we need it in that format in order to work with it in another "specialized" software program. But, when we export it, the 2 decimal places attribute is gone and we end up with various decimal place lengths again. The "specialized" software does not allow us to edit a fields attributes. Does anyone know how we can export the table and keep the 2 decimal place attributes for the field???? Need answer ASAP!!!! Thanks to whomever can help!!! I would really appreciate it!!!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Attributes of num field disappear when exported as DBASEIV .dbf file!
- Thread starter selaine
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question