ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Save csv format to dbf format (https://www.excelbanter.com/excel-discussion-misc-queries/56225-save-csv-format-dbf-format.html)

mdelasaux

Save csv format to dbf format
 

I have a .csv file with 13 columns of data opened in excel. I make a
few changes to a field and then want to save to .dbf format.

After saving as .dbf when I open the file only column 1 data is
present.

Any insights into where the rest of the data goes? Why does the data
disappear?

Thanks, Mike


--
mdelasaux
------------------------------------------------------------------------
mdelasaux's Profile: http://www.excelforum.com/member.php...o&userid=28889
View this thread: http://www.excelforum.com/showthread...hreadid=486365


Bryan Hessey

Save csv format to dbf format
 

Try using Notepad and open your .dbf file in there to check if the
format is being ccorrectly written but not being correctly read.



mdelasaux Wrote:
I have a .csv file with 13 columns of data opened in excel. I make a
few changes to a field and then want to save to .dbf format.

After saving as .dbf when I open the file only column 1 data is
present.

Any insights into where the rest of the data goes? Why does the data
disappear?

Thanks, Mike



--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=486365



All times are GMT +1. The time now is 09:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com