excel2010 to dbf

[simc...@yahoo.com]

Dear All,

 

Any body know  how convert  Excel 2010 file  to (.dbf ) file please help? or ArcSWAT can support other file format ?

 

Regards

 

Monichoth

[Jim Almendinger]

Do a Google search on a plug-in to Excel that will allow you to write dbfs.  I found one some time ago and it seems to work fine, so I know they're out there.  Otherwise, you can transfer the Excel worksheet as a table to Access, and then export the table to dbf (I think), but that's a hassle.  

-- Jim

Dr. James E. Almendinger, Senior Scientist
St. Croix Watershed Research Station
Science Museum of Minnesota
16910  152nd St. N
Marine on St. Croix, MN  55047
tel: 651-433-5953 X 19
fax: 651-433-5924
email: din...@smm.org
web: www.smm.org/SCWRS/

[simc...@yahoo.com]

Dear All

 

 

Thank so much for help

 

Monichoth

[Sammons, Nancy]

The tables and data can also be in .txt format with examples in install folders.

--
You received this message because you are subscribed to the Google Groups "ArcSWAT" group.
To post to this group, send email to arc...@googlegroups.com.
To unsubscribe from this group, send email to arcswat+u...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/arcswat?hl=en.

This electronic message contains information generated by the USDA solely for the intended recipients. Any unauthorized interception of this message or the use or disclosure of the information it contains may violate the law and subject the violator to civil or criminal penalties. If you believe you have received this message in error, please notify the sender and delete the email immediately.

[Naresh Pai]

If you have MS Access, you could import .xlsx files and then export it is as a dbase (.dbf) file.

Naresh

[Jonathan Knox]

You can also do this in ArcGIS. Save the .xls as a csv and then import into Arc- then export it as a .dbf. It's a pain to do manually but if you have the data as a .csv you can script the rest.

- Jonathan

[ArcSWAT]

Hi Monichoth,

I work with Excel 2010, but in order to save to .dbf format, I open the file (xlsx) with the "Open Office Calc" and than save as .dbf.

Hope I'ts work with you too.

[Iman Fazeli Farsani]

Hi Monichoth,

 

You can use of xls-converter or xls to dbf converter software. It is very simple

 

xls-converter link:

http://www.file-converters.net/download/xls-converter.exe

 

 xls to dbf converter link:

http://www.whitetown.com/download/xls2dbf.zip

 

But, you pay attentian that those softwares are trial version.

 

Regards,

Iman Fazeli Farsani
 

[Dave_R]

Openoffice or Libreoffice

[Jim Almendinger]

Use Google to search for an Excel add-in that will allow writing dbf files.  I'm pretty sure some exist. 

-- Jim

--
You received this message because you are subscribed to the Google Groups "ArcSWAT" group.

To unsubscribe from this group and stop receiving emails from it, send an email to arcswat+u...@googlegroups.com.

To post to this group, send email to arc...@googlegroups.com.

Visit this group at http://groups.google.com/group/arcswat.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

---

NOTE: This message was trained as non-spam. If this is wrong, please correct the training as soon as possible.
Spam
Not spam
Forget previous vote

[Djesser Zechner Sergio]

1st In Excel, select your data and click Insert -> Table.....It will create bondaries to the spreedshed.

2nd open the excel spreedshed directly in ArcGIS (Add Data - double click on the excel.xls(x) file, the spreedshed appears)

3rd Open Attribute Table and Export Data as DBF file

--

Djesser Zechner Sergio

Sanitary and Environmental Engineer / UFSC / 2012.2

AMBIPLAN - Engenharia Ambiental SS LTDA and 

SERENCO – Serviços de Engenharia Consultiva SS Ltda

Av. Sete de Setembro, 3566 - Centro -

Curitiba – PR - CEP 80250-210

www.serenco.com.br

+554197111114

+554132339519

dje...@serenco.com.br

djesser...@gmail.com

[Naresh Pai]

You can also import a spreadsheet using Access 2010 (External Data tab on the ribbon) and then export it as dbf. Use the dBase File option (Under External Data -> Export -> More)

Naresh