arcgis-desktopdbfexcel
I have a .dbf file from arcgis 10.1 and it contains 370 columns and 582 rows. I want to open it in excel but it can only open 256 columns no more than that.
There's a way that I can break a file and then merge them but that's quite time consuming.
I've got to know that by using VBA we can read dbf files the way is it. Anybody please suggest me what to do to open it in one excel sheet through VBA or any other way.
You can use the query to report, or the export functions.
I will wait on your reply to the comment question and fill in more detail.
In python it's possible. I have done something similar.
This tutorial was very helpful for me: basic-excel-driving-with-python
With this, you can open an existing excel file and add/change values to whatever you want.
Once you have setup a python script that works for you, you can change it for reading parameters so you can add it as a script in ArcToolbox. Then you can call it in ModelBuilder.
Some code that can help you, basically it export to excel an attribute table:
import win32com.client as win32
excel = win32.gencache.EnsureDispatch('Excel.Application')
wb = excel.Workbooks.Add()
excel = win32.gencache.EnsureDispatch('Excel.Application')
wb = excel.Workbooks.Add()
#Fields List
desc=arcpy.Describe(LayerToExport)
Fields=[]
for Fi in desc.fields:
if Fi.type != "Blob" and Fi.type != "Geometry":
Fields.append(Fi.Name)
iFi = 1
for Fi in Fields:
excel.ActiveSheet.Cells(1,iFi).Value = Fi
iFi+=1
#Each row
rows = arcpy.SearchCursor(LayerToExport)
iRow=2
for row in rows:
iFi = 1
for Fi in Fields:
excel.ActiveSheet.Cells(iRow,iFi).Value = row.getValue(Fi)
iFi+=1
iRow+=1
# Clean up cursor and row objects
del row
del rows
wb.SaveAs(outFile)
wb.Close(False)
Note: As this use win32com, VBA function are supported. So it's possible you can use your "TransferSpreadsheet" function.
Best Answer
If you're able to use python, simpledbf (https://pypi.python.org/pypi/simpledbf/0.2.4) can read the dbf file and export to a csv: