ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   writing to a DB4 file (https://www.excelbanter.com/excel-programming/370785-writing-db4-file.html)

dharp

writing to a DB4 file
 
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[_3_]

writing to a DB4 file
 
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




Tom Ogilvy

writing to a DB4 file
 
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




All times are GMT +1. The time now is 12:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com