I am using the following Excel 2000 VBA code to open a .txt file and save it as a .dbf file. When I open the .dbf file in Excel, any data longer than the standard column width is truncated. Any suggestons on why this is happening.
Sub SaveDBFFile()
Workbooks.OpenText Filename:= “Sales"...
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.