Auto import and export *.dbf 1

[DugyWugy]

Hi,

I created a small VB program to start some related programs. One of these programs uses run-time .dbf as the background database.
Is there a way to automatically convert these *.dbf's into a table in Access for updating with a form and then automatically exporting back into *.dbf? The import and export functionality would come from a button on the form.
I have the forms and source data tables designed - I just need to provide a means of auto-importing and auto-exporting.
I'm trying to make this very simple for some customers that have no computer experience.

 

[PaulF]

Look at TransferDatabase in the Help Files


PaulF

 

[DougP]

I would just link to the .dbf files instead of converting them and re-converting them

In Access click the Tables TAB then right click in the white space. Click Link Tables...
In the "Files of type" at the bottom click dBase III or whatever version you have.
Find your dBase file(s) and Index if there is one.
Next create your form from that table.
When you do anything in Access now it automatically saves the data back to the dBase file. no converting needed.
That's why Access has a Gold Key for it's Icon it can read just about any data on the Planet. It's your gold pass key to open Data....


DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.