I need to get data from my access 2000 DB to another contact management software on a regular basis. I would like to use the most simple solution. One issue is that the software can only import dbf files. I have thought a couple of ways to do this
1.export the table in dbf format but the downside is that this is another operation.
2. Link the table to a dbf file. I tried this and it seamed to work but I have a problem. Many of the fields are being cut short. The way i done it was as follows.
a/ I linked the table to an Excel file.
b/ I then changed the Excel to a dbf file I think this is when the fields were cut short.
Can anyone help?
1.export the table in dbf format but the downside is that this is another operation.
2. Link the table to a dbf file. I tried this and it seamed to work but I have a problem. Many of the fields are being cut short. The way i done it was as follows.
a/ I linked the table to an Excel file.
b/ I then changed the Excel to a dbf file I think this is when the fields were cut short.
Can anyone help?