Import Tables

[joltremari]

I have some .dbf files that I import as tables once a month. I'm wondering if this would be possible with a macro.

thanks

JO

 

[jwindon]

What type of program produces .dbf files?

Is using Excel Tables or an Access Table an option? If so, you could just link those tables and never import again.

 

[joltremari]

We have a Visual Basic program that takes a data file we receive from a company and converts it into a .dbf file. I don't know why. The two guys who did all of that are no longer employed with us.

We had the tables linked at first, but some of the complex queries we are running will not work if the tables are linked. So I thought if we could just make a macro that would import the files that would save us some time.

JO