I have linked directly from Access to Excel. I then converted the Excel file to DBF file. When the table updates in access this updates the dbf file. I can then import the dbf file in my other management software. The problem I have is that the contents of the field are being cut short. By this...
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...
Thanks for your reply. Postcodes are the UK equivelent of ZIP codes but they differ in their format BT389JN, XF432Y or GD1 3RK. I believe that I am right in Saying that they always have 2 letters and then a numeric number as standard. I have had another look a my table and I think it may not be...
I wish to format a name and address table in an access DB 2000 to "Title case". I can correct the most of the fields like name, Address line1 , Address line 2 and so on. When I get the Address line 4 and 5 I have the problem that there are some postcodes in these instead of the postcode field...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.