Problem in creating dbf files

[anurag nayak]

Hi,

 

I am Anurag Nayak, a Post Doc a Boise State University. I am trying to run ArcSWAT for Reynolds Creek Experimental Watershed, Idaho using 45 years of hourly precipitation data. But I can not create dbf files using excel as it can only take about 65000 data records. I tried to create 6 or 7 dbf files and merge them using notepad and also tried to create a single dbf file using a free dbf file managere (downloaded from internet) but in both the cases ArcSWAT did not like the format.

 

Can anyone please tell me how can I create a dbf file with nearly 400,000 data records which will be compatible with the ArcSWAT.

 

Thank you

Sincerely

 
Anurag Nayak

[Jim Almendinger]

Anurag --

Perhaps you could use Access to append smaller txt, dbf, or csv files (created by Excel, for example) into a much larger table, that you can then export as a dbf.  

Or -- if you're starting with a large ascii text file to begin with, you can probably read it directly into Access (it can import text files, with some guidance on how to recognize each data field).  You could then export the table as a large dbf if needed.

-- 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/

[willem vervoort]

Your best bet is probably to use a command line maths program such as
MATLAB (Commercial, but cheap for students), R (www.r-project.org,
free, GNU) or Mathematica (commercial) to create those files. Or using
a real database program (MS Access for example or a GNU variation)

Willem

[anurag]

Thank you Sir for you help.

I was able to create a dbf file for 40 years of precipitation data
following the instructions given by you. When I used this dbf file as
an input to the ArcSWAT, the model failed. Though it created a mdb
file in the working directory with the same precipitation data. Do you
have any idea why this error occured?

Once again thank you for your help.

Anurag

> web:www.smm.org/SCWRS/- Hide quoted text -
>
> - Show quoted text -