open DBF and save as CSV

[_t_oak]

Hi, i'm relatively new to using Excel and writing macro's. I have 11 folders with around 130 DBF files with Data from a customers machine, I need a way to automate the conversion of these to CSV or xslx so i'm not having to manually open and save as almost 1500 files.

thanks,

Tom

 

[Joe4]

Welcome to the Board!

If you open a blank Excel file, turn on your Macro Recorder and record yourself opening, saving, and closing one of these files, then shutting off the Macro Recorder, you will have the code you need to do that part of it. Then, you just need to wrap that code in a loop that loops through all the files.

If you need help with that, follow the steps I mentioned above and paste your recorded code here for us to see.
Then let us know the file paths where these 130 DBF files are found.

 

[_t_oak]

Welcome to the Board!

If you open a blank Excel file, turn on your Macro Recorder and record yourself opening, saving, and closing one of these files, then shutting off the Macro Recorder, you will have the code you need to do that part of it. Then, you just need to wrap that code in a loop that loops through all the files.

If you need help with that, follow the steps I mentioned above and paste your recorded code here for us to see.
Then let us know the file paths where these 130 DBF files are found.

hi joe,

i did some googling and did pretty much exactly that and am now wrapping it up.
thank you for the advice

 

[Joe4]

i did some googling and did pretty much exactly that and am now wrapping it up.
thank you for the advice

Excellent! Glad to hear it!

If you run into any trouble, post your code and question here, and we can help you put the finishing touches on it.