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

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

"dharp"
egroups.com...
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

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

--
Regards,
Tom Ogilvy




"dharp" wrote:

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