Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

convert an csv Xcel file to a dbf file

Status
Not open for further replies.

lovettj

Programmer
May 22, 2007
10
US
Hi,

I need to convert a csv file to a dbf file using vbscript. Could anyone please help. I can do it manually with file save as in Xcel but I need to automate this process.

Thanks in advance.
 
Open the file using the Excel object...you should find examples in this forum. When you save it specify the format... here are the constants you may need when saving.

Const xlDBF2 = 2
Const xlDBF3 = 8
Const xlDBF4 = 11

--------------------------------------------------------------------------------
dm4ever
My philosophy: K.I.S.S - Keep It Simple Stupid
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top