writing to a DB4 file

[dharp]

Hello,

I am trying to write some data to a DB4 file so that it can be used by
ArcGIS later in the program. Can this be done using VBA?

Thanks,
Dylan

 

[NickHK]

You can connect from Excel to most common DB formats. I assume that ODBC
would do it.
Or you can save Excel file in DB4 format.

NickHK

 

[Tom Ogilvy]

If the data is set up like a database you can do file=>Save As, and select
dbf 4 as the file type

if you are using vba
Activeworkbook.Saveas filename:="C:\myfolder\mydbf.dbf", fileformat:=xldbf4