ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Having issues with exporting (https://www.excelbanter.com/excel-discussion-misc-queries/173453-having-issues-exporting.html)

Munkeeric

Having issues with exporting
 
I am trying to export a spreadsheet out to a file type that is compatible
with my GIS. In older versions of Excel, one could export out to a .dbf
file, which was usable. Now, that option has been removed, so I'm stuck
having to use a text file. However, when choosing .csv as the type, all
cells that contained alpha-numeric values were deleted. This filetype is the
type desired by my datbase admin. Anyone know why this might be occuring?

HKaplan

Having issues with exporting
 
What version of Excel are you on? Saving as CSV should absolutely not
delete values.

Munkeeric

Having issues with exporting
 
I am using 2007. Do .csv formats includ anything such as format type( text,
numbers, both)? I am wondering if maybe the GIS si the problem.

David Biddulph[_2_]

Having issues with exporting
 
CSV is just text, separated by commas. It contains no formatting
information.
--
David Biddulph

"Munkeeric" wrote in message
...
I am using 2007. Do .csv formats includ anything such as format type( text,
numbers, both)? I am wondering if maybe the GIS si the problem.





All times are GMT +1. The time now is 02:17 AM.

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